How to print as pdf all sheets in one single qlik

[#1]

How to print as pdf all sheets in one single qlik ?

[deepakk]

hi,

Use the below code.

ActiveDocument.PrintAllSheets true

ActiveDocument.GetApplication.Sleep 2000

set fso = CreateObject("Scripting.FileSystemObject")

fso.MoveFile PdfPath , NewFilePath

Points to be noted. IN Pdf Printer Setting -- > Printing Preference there is tab for Save.

Provide a UserDefined Path eg: C: \ Test .pdf.

Using Scripting.FileSystemObject move the file to a new file so that pdf doesnt get overwritten by other sheets.

[#3]

Hi Deepak,

Thanks .. This macro generates the PDF for each sheets and prompt us to stores them as saperate files.

I have a requirement of storing them on the same PDF file by appending the sheets.

Regards

[deepakk]

HI Surender,

In your case you might have to create it using edit report option in reports and the call the report.

I am not sure if we can append the entire sheet into one. But we can drag multiple objects from different sheets and can add into the reports.