Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
pkpandey
Contributor III
Contributor III

Bypass window SAVE AS in creating pdf report

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.

2 Replies
Sarah_Miller
Former Employee
Former Employee

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
Contributor II
Contributor II

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