export to save sheet in pdf is not working.

[Anonymous]

Hi All,

I am working on a macro export to save sheet in the pdf format on local drive, macro is executing fine but file is not getting saved in the given path. Please help me to save pdf in the given path.

I am using PDFCreator & below macro to export sheet :

sub Export

printReportPDF "H:\Test.pdf"

ActiveDocument.GetApplication.Sleep 5000

ActiveDocument.sheets("Test").Print

ActiveDocument.GetApplication.Sleep 5000

end sub

'===========================================================================

Function printReportPDF(pdfOutputFile)

Set WSHShell = CreateObject("WScript.Shell")

WSHShell.RegWrite "HKCU\Software\QlikviewPDF\OutputFile", pdfOutputFile, "REG_SZ"

WSHShell.RegWrite "HKCU\Software\QlikviewPDF\BypassSaveAs", "1", "REG_SZ"

Set WSHShell = nothing

End function

Thanks

Sattya

[Colin-Albert]

The QlikView services run in session 0 on the server so do not have access to mapped drives.

Can you reference the file using a UNC path, that should work.

Also be aware that some macro functions do not work on QlikView server.
macros not working on server

[Anonymous]

Thanks Albert for quick. I am using Qlikview desktop & I have full permission on the given drive.