3 Replies Latest reply: Aug 28, 2014 6:55 AM by Halmar Heijnen RSS

    CMD reload via MS Access VBA

    Halmar Heijnen

      Hello all,

       

      I want to reload a Qlikview document with a commandline via a MS Access macro.I made a simple macro like this:

       

      Call Shell("cmd.exe C:\Program Files\QlikView\qv.exe /r C:\Users\HH01\Google Drive\Sjabloon\Workbooks\3. Datamodel\SourceListGenerator.qvw pause", vbNormalFocus)
      

       

      The next thing i want is to change some variables in de qvw. The input for that variables are inside of a textfield in a Accessform.

      For that I made a macro like this:

       

      Call Shell("cmd.exe C:\Program Files\QlikView\qv.exe /r /vQVDmap=" & Forms![AP Qlikview Console]![Tekst59] & " /vQVDprefix=" & Forms![AP Qlikview Console]![Tekst73] & "C:\Users\HH01\Google Drive\Sjabloon\Workbooks\3. Datamodel\SourceListGenerator.qvw pause", vbNormalFocus)
      

       

      But they are both not working.

      can someone help me with this macro?

       

      Thanks in advance,

       

      Halmar