Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
See this document: QlikView automation by external VBScript scripts
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 .
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.