Bypass window SAVE AS in creating pdf report

[pkpandey]

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.

[Sarah_Miller]

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

[luisvalenzuela]

hi

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