Export to excel on reload problem

Tue, 16 Feb 2010 13:44:18 GMT

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

Regards

Adrian

obj = ActiveDocument.GetSheetObject("TB01") ExporttoExcel()

topic Export to excel on reload problem in QlikView

Export to excel on reload problem