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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.