send to excel not working in qlikview 9.0

[SunilChauhan]

hi,

i am trying to export a table in excel .but unfortunately its not working.

i am using macro

Sub SendToExcel

set

obj = ActiveDocument.GetSheetObject("CH2019")

'........data of TB01 object is read into obj'

"D:\Qlik2Finance\Work\TOM\\filename.xls"

'.....set path of excel file with default name'''Sub

End

post reload i want to export

docment properties/triggers/onpostreload have action SendToExcel.

any help

[pover]

Is that your macro or did it not copy all the macro? If you have trouble copying the script, look for the post in the forum to copy script into the forum or copy it first to notepad and then to the forum so that we can help you.

Regards.

[SunilChauhan]

thanks for your kind reply

macro is not an issue.

because it is working on button click.but on post reload it is not working.

steps i follow is

settings ->document properties->triggers->onpostreload ->add action->sendtoexcel(Microname)

looking for your response.

Tom