Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Hemanth458
Contributor III
Contributor III

OnPostReload does't work in Qlikview Personal Edition

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.

 

 

 

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

Maybe some of the various settings prevent the execution. Take a look on the security-tab within the document - and the user-properties and also within the script-editor on the setting-tab (not in the menu else in the bottom-left area of the window).

Further you wrote by "manually" reloading - if this mean to manually start a task within the qmc then it couldn't work because on this state no ActiveDocument exists.

- Marcus

View solution in original post

4 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Maybe some of the various settings prevent the execution. Take a look on the security-tab within the document - and the user-properties and also within the script-editor on the setting-tab (not in the menu else in the bottom-left area of the window).

Further you wrote by "manually" reloading - if this mean to manually start a task within the qmc then it couldn't work because on this state no ActiveDocument exists.

- Marcus

View solution in original post

Hemanth458
Contributor III
Contributor III
Author

Thank you Marcus,

Then if I want to execute the same thing in Qmc than what changes I need to do.

Consider me  new to Qlikview if you have documentation or Script

Share it with me 

Thank you very much in Advance

 

 

marcus_sommer
MVP & Luminary
MVP & Luminary

Take a look here: Run-Macro-after-reload-in-QV-Server

- Marcus

Bill_Britt
Support
Support

OnPostReload  will not work in the QMC.

 

Bill

Bill - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.