0 Replies Latest reply: Aug 6, 2012 10:42 AM by Derek Jones RSS

    Run a macro from bat file

    Derek Jones

      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