topic Bypass window SAVE AS in creating pdf report in Qlik Learning Discussions

Bypass window SAVE AS in creating pdf report

pkpandey — Fri, 29 Aug 2014 07:09:27 GMT

Hi All

How to bypass SAVE AS window in Qlikview from a macro and save the file automatically to a given location. I am sending a file where cliking on the button "PRINT REPORT TO PDF" is generating a pdf file but it is asking for the file saving location. This I want to skip and file should be saved automatically.

Re: Bypass window SAVE AS in creating pdf report

Sarah_Miller — Wed, 10 Sep 2014 19:11:03 GMT

Hi Pradeep,

Thank you for your interest in the Education Services Forum and for contributing to our discussions. We noticed that your questions hasn't been answered yet so we asked a team member to take a look.

He was not able to answer however. He sited "the file that is being created is not the “name” they choose, or the folder location they want. At least not for me. Could be it is working differently in different versions of QlikView and potentially a bug – or something that R&D stopped supporting without any consideration for how it has been used in the field".

In order to ensure you get an answer, I posted your question in the following discussions and copied the original post. This should help get you more assistance.

http://community.qlik.com/message/606731#606731

http://community.qlik.com/thread/132817

Re: Bypass window SAVE AS in creating pdf report

luisvalenzuela — Wed, 10 Sep 2014 20:25:19 GMT

Incorporated into the code of your macro

Set sPDFPath_dest ="C:\Download\"

If Not objFSO.FolderExists(sPDFPath_dest) Then

Set newfolder = objFSO.CreateFolder(sPDFPath_dest)

End If