I have set the document properties to run this maro after reload
sub
set
"c:\temp\Testajr.xls"
end
sub
If I go into the edit module window and test it, it creates the file as required. However if I reload the document it reloads and then opens the edit module window and highlights the set obj line in black.
Does any one know why this would happen. All I want to do is reload the doc and have it export the table TB01 to Excel