Auto Export to Excel File (upon reload) using qv macro

[#1]

Hi,

I manage to find a lot of different scripts on line to export to csv or excel format and here's what I have now:

Sub ExportFile

ActiveDocument.Sheets("SH01").Activate

set obj1 = ActiveDocument.GetSheetObject("CH01")

obj1.ExportBiff "C:\paht\" & "FileName" &Right("0" & Day(Now)-1,2)&Right("0" & Month(Now),2)&Year(Now())&".xls"

ActiveDocument.GetApplication.Sleep 5000

End Sub

Still, everytime I reload the qlikview, this export script doesn't seem to run and there's no excel file being saved. Only when I go to Tools >> Edit Module and test/run the macro that the excel file is being exported and saved in the specified location. Is there anything I can do so that when I reload the macro will run also?

Appreciate the help!

Regards,
Joy

[trdandamudi · Accepted solution]

I ran a sample test and it is working. Pleasee  take a look at the attached file. Take a look also at the below:

Go To DocumentProperties

Click the tab "Triggers"

Under "Document Event Setting"  select "OnPostReload"

Click on "Edit Action(s) button and you will see the actions

Hope this helps...

Note: Please make sure, that in the macro you update the correct file path. I am using Temp\Tuesday as my path.

[beck_bakytbek]

Hi Joy,

i am sure, this topic will resolve your issue or you can finde better solution for your business-situation

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

beck

[#4]

Thank you!!

[trdandamudi]

Awesome... Glad able to help out....

[DavidD]

It's important to note that the solution works indeed when reloading locally but does not work when reloading through a task on the management console unfortunately...At least it didnt work for me. If someone has a way, besides NPrinting, I'd be glad to see it!