Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am sharing step by Step process what I had done.
ctrl+M
Macro code:
Sub ExportToExcel
ActiveDocument.Sheets("SH01").Activate
set obj1 = ActiveDocument.GetSheetObject("CH01")
obj1.ExportBiff "C:\Users\Desktop\Qlik Development\Testing_MacroData.xls"
ActiveDocument.GetApplication.Sleep 1000
End Sub
Then
Ctrl+Alt+D
Selected Trigger->OnPostReload->AddAction->Add->External->Run Macro-> Macro Name : ExportToExcel->Ok
Whenever I reload the script manually it doesn't create a file in a specified path.
But when I Clik on test it generated a file in a specified path.
I need whenever the task gets reloaded it generates a file.
Hi,
You need to set this trigger under document properties under triggers tab. Also, OnPostReload only works using the client.
Bill
Hi,
You need to set this trigger under document properties under triggers tab. Also, OnPostReload only works using the client.
Bill