Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
it_bi_vg
Contributor
Contributor

Run Macro from Console

Hello,

I've the application "A" that runs this macro, after Event PostReload or on demand from button.

set objExcel=ActiveDocument.GetSheetObject("CH01") 
objExcel.ExportEx filepath,4

I' ve publisher and I'd like to schedule  it from Management Console every day , but I can't reload this macro. It doesn't work. 

I don't like to use Windows Scheduler, I prefer to use only Qlikview tools.

I've red this: The OnPostReload event is not fired after a server reload. 

if it wasn't possible, I would run on demand from other application "B".

In other words, Application "B" has a button (on demand from users), it opens application "A" and run macro or when I load script, it executes statement or file.bat that export table to qvd.  

Thanks for your help

 

 

11 Replies
it_bi_vg
Contributor
Contributor
Author

the problem isn't path, because I've used the same files and I replaced the simple statement to copy and it works.
Maybe it doesn't work because I can try to open an other qvw file, maybe it wants some parameters to open concurrent qvw.
pradosh_thakur
Master II
Master II

Hi 

I hope you are trying this

 

1: The bat file is just opening the  ABC qvw.

2: The ABC.qvw is in the server /desktop.

3: This qvw has an on open trigger , which runs a macro

4: Macro stores QVD/ does whatever it is supposed to do.
5: Bat file closes and ABC.qvw closes

 

I have tried something similar above and it worked for me

 

Regards

Pradosh

 

Learning never stops.