Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created the batch file and written some macro in the application.
How we can send the mail and exporting data by using macro with the batch file calling?
When am clicking in the macro for test then everything working fine as per my micro code like sending mail and exporting data.
My Batch file code:
"C:\Program Files\QlikView\Qv.exe" /vvSendSalesMail=1 /NoSecurity "D:\Macros_Test.qvw"
Thanks in advance,
Ajay
Dear ajay,
you can create trigger after reload
->
Settings - > Document Property -> Triggers -> onpostreload ->addaction-> macroname
macroname -> it will be mail related macro name
Dear ajay,
you can create trigger after reload
->
Settings - > Document Property -> Triggers -> onpostreload ->addaction-> macroname
macroname -> it will be mail related macro name
Hi
I don't think that you can fire a macro in a QVW document directly from the command line. You could use an OnOpen trigger to fire the macro, or move the macro code to an external vbs script that create a Qlikview object, opens the document and performs the required actions. The object model is the same once you have created the object and opened the document.
HTH
Jonathan
Following command works fine with me
"C:\Program Files\QlikView\qv.exe" /l /noSecurity "D:\Production\Mail Distribution\Indoco_SIM_HOD_WISE_SUMMARY.qvw"
Please try
Vikas
Thanks Pandiarajan its working as per current requirement.
Ajay