Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

derekjones
Contributor II

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

Tags (2)