topic Re: Auto Export to Excel File (upon reload) using qv macro in QlikView

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

Wed, 25 Nov 2020 16:16:04 GMT

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

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

trdandamudi — Wed, 18 Jan 2017 01:43:18 GMT

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.

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

beck_bakytbek — Wed, 18 Jan 2017 16:08:54 GMT

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

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

Fri, 20 Jan 2017 01:51:20 GMT

Thank you!!

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

trdandamudi — Fri, 20 Jan 2017 03:17:43 GMT

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

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

DavidD — Wed, 15 Jan 2020 20:53:41 GMT

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!