I need to start a macro once a day in an specific time, so I create this Macro in the QV with an IF statement to check the time and I´m trying to use a bat file to open the QVW in the server, execute the macro and close the project.
The problems are:
1) If I run the bat file from the server desktop it works fine. When I use Windows Server schedule it executes the QVW but don´t run the macro.
2) I´m using the /R parameter but I don´t need to load the data. I need to open the QVW execute the macro and close the QVW. Exists any parameter or a command to be inserted in the macro to close the Desktop QV withou saving?
For question 1, try placing the macro code in a vbs script file and schedule this (or call it from the bat file).
set Qv = CreateObject("QlikTech.QlikView")
Qv.OpenDoc "C:\Folder\Filename.qvw"
set QvDoc = Qv.ActiveDocument
INSERT MACRO HERE and start every call with "QvDoc."
Qv.Quit
Question 2: The /R parameter is optional. /R will reload the script, save the document and close QlikView. If you don't add a parameter there it will just load the document. See section 7.1 in the QlikView reference manual.
I have a batch script which reloads QVW file and triggers macro in it. It is working file when i run manually but when i schedule batch through my scheduler its not working.
