Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaykumar1
Creator III
Creator III

Batch file not working.

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

1 Solution

Accepted Solutions
pandiarajan
Creator
Creator

Dear ajay,

   you can create trigger after reload

->

Settings - > Document Property -> Triggers -> onpostreload ->addaction-> macroname

macroname -> it will be mail related macro name

View solution in original post

4 Replies
pandiarajan
Creator
Creator

Dear ajay,

   you can create trigger after reload

->

Settings - > Document Property -> Triggers -> onpostreload ->addaction-> macroname

macroname -> it will be mail related macro name

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vikasmahajan

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
ajaykumar1
Creator III
Creator III
Author

Thanks Pandiarajan its working as per current requirement.

Ajay