topic Re: Run qlikview macro code throught batch file or any other method in QlikView

Run qlikview macro code throught batch file or any other method

sunilkumarqv — Wed, 08 Oct 2014 11:11:00 GMT

Hi Guys,

I written macro code for send a mail of attached file that's works fine.I need to run this code without opening the Qlikview application

please suggest me how to do that.

Re: Run qlikview macro code throught batch file or any other method

Wed, 08 Oct 2014 11:16:18 GMT

What is the attachment? Is it a report out of the Qlikview document? If it is a document that already exists then you can embed the macro in Excel instead and have it run on open, or you can create a batch file to call a .vbs file and run it that way. The vba engine exists outside of Qlikview, so although that has the macro editor, you dont need it to run the script.

Re: Run qlikview macro code throught batch file or any other method

Gysbert_Wassenaar — Wed, 08 Oct 2014 11:25:07 GMT

See this document: QlikView automation by external VBScript scripts

Re: Run qlikview macro code throught batch file or any other method

sunilkumarqv — Wed, 08 Oct 2014 11:46:02 GMT

Hi,

But in macro code is used to print report to specified path, then taking the attached file and sending .can we manipulate code according to my requirement .

Re: Run qlikview macro code throught batch file or any other method

sunilkumarqv — Wed, 08 Oct 2014 11:50:20 GMT

Hi Noel,

the attachment was pdf file .which i was able to print then save it into specified path ,then picking the same and send the reports .

Please check Congratulations ! Gysbert Wassenaar post and then synchronize to my requirement.