Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
derekjones
Creator III
Creator III

Run a macro from bat file

Hi All

Can you run a macro from a bat file? I can't use a trigger on reload or open to activate the macro as the qvw is reloaded on the Server, then copied to another machine/location so it can be opened by this bat file and the macro run to export bitmaps that a Videowall uses. If I ran the macro on open or reload, that macro would run on the Qlikview server which is what I'm trying to avoid.

Here's my bat script if it helps?

COPY "\\<serverlocation>\VideoWall.qvw" "\\<Videowalllocation>\"

START "My script" /Max "C:\Program Files\QlikView\Qv.exe" \\<Videowalllocation>\VideoWall.qvw"

I've tried using vbs to run the macro, however wierdly it appears to open the Qlikview application twice as the instruction from a vbs script requires OpenDoc e.g.

set Qv = CreateObject("QlikTech.QlikView")

Set QvDoc = Qv.OpenDoc (\\<Videowalllocation>\VideoWall.qvw)

I can't not open the app in the bat as if I open it in vbs it does not maximise the app so the bitmap exports are not of the entire page.

Any help or advice will be appreciated.

My thanks in advance

Derek

0 Replies