topic Re: Macro to create PDF in QlikView

Macro to create PDF

Sun, 02 Sep 2012 16:15:52 GMT

Hi,

I have gone through the interesting discussion " Macro to export AND mail report as PDF" by different authors in the discussion started by in October 2010 by JochenAndries (using Bullzip PDF). Em Vau suggested in Februaru 2012 to use QlikViewPDF. Thanks to both and others contributed on the same discussion. Excellent automation tips!

I have used QlikVewPDF. I have combined sub code and function code for simplicity. The code works fine but QlikViewPDF printer dialogue opens, which should not. The PDF file should be saved automatically.

I am attaching image of code, image of saveas dialog and the QVW document.

Kindly suggest how we can avoid the SaveAs dialog.

Regards,

KSP

Code

Re: Macro to create PDF

Mon, 03 Sep 2012 04:03:18 GMT

I use PDF-XChange and the method should work in your case as well. Open 'Devices and Printers' in the windows Start menu. Look for QlikViewPdf in Printers and Faxes section. Right-click on the icon and select 'Printing Preferences'. Scan through the sections and you should find a place to change the 'Save' preferences. For example, in PDF-XChange, it is in 'Save' section.

Re: Macro to create PDF

omid5ive — Mon, 03 Sep 2012 04:11:00 GMT

hi kspalani

you can use this code for printing pdf with qlikview PDF

sub printRP01

printReportPDF "C:\Temp\18T.pdf"

ActiveDocument.GetApplication.Sleep 2000

ActiveDocument.PrintReport "RP02", "QlikViewPDF"

ActiveDocument.GetApplication.Sleep 10000

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

Re: Macro to create PDF

Mon, 03 Sep 2012 05:39:48 GMT

Hi Omid Ebrahimi

Still I get SaveAs dialog. I wish to avoid it and save directly without user intervention,

If you can guide, it would be great.

Regards,

KSP

Re: Macro to create PDF

Mon, 03 Sep 2012 06:06:10 GMT

Hi Palani,

Please find the attached file for PDF Export n Mail, hope it will help you to solve the issue.

Re: Macro to create PDF

omid5ive — Mon, 03 Sep 2012 06:30:51 GMT

i attached it

you should set your mail and password on macro

Re: Macro to create PDF

Mon, 03 Sep 2012 12:23:28 GMT

Thanks Omid Ebrahimi and qvarunprasadh

Thanks for your quik help. I tried creating PDF from the scratch through Bullzip. No Luck.

I am running on Windows 7 Professional 64bit. Perhaps Windows 7 64 bit is not allowing direct saving of PDF, without a SaveAs dialog capturing location and filename.

The code you have shared seemed to be working perfect. May I know which OS you are operating on?

Regards,

KSP

Re: Macro to create PDF

omid5ive — Mon, 03 Sep 2012 12:48:36 GMT

i use os same you

windows 7 64 bit

Re: Macro to create PDF

Tue, 04 Sep 2012 06:06:15 GMT

Hi Omid Ebrahimi,

Thanks for sharing the doc. Appreciate. I copy pasted the script andd created same variables. Following are observed:

1. PDF printing still opens the SaveAs dialogue

2. In mail, I changed the port number to 25 (as advised by my hosting company). Mail script neither shows success nor error. This is weird.

If you can assist, it would be great. I am attaching my doc.

Regards,

KSP

Re: Macro to create PDF

omid5ive — Tue, 04 Sep 2012 09:04:54 GMT

hi kspalani

i check it

it work correctly with no saveas dialog

are you create qv folder in drive c?

and for second question

icant undrstand your problem can you explain it?

Re: Macro to create PDF

Tue, 04 Sep 2012 09:50:35 GMT

Hi Omid Ebrahim,

Thanks. I ran your qvw on my machine.

Print PDF: I still get SaveAs dialog. I am sending printer settings at my end. May be we can compare to know any settings make problem.

EMail:

1. I only changed the following value from 465 to 25 (my hosting company advice)

.item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 '465

2. As per the code below, either I should get message SendMail Failed" or "it was successful".

But I do not receive any of these messages. Unfortunately I use QV11 which no debugger for macros.

On Error Resume Next

oEmail.Send

If Err Then

WScript.Echo "SendMail Failed:" & Err.Description

else

msgbox("it was successfull")

End If

Thanks again Omid for your support. Help as much as you can.

Regards,

KSP

Re: Macro to create PDF

omid5ive — Tue, 04 Sep 2012 10:16:28 GMT

are you set it your default printer?

and for email
are you shure you set your mail and password correctly?

Re: Macro to create PDF

Wed, 05 Sep 2012 02:40:35 GMT

Hi Omid Ebrahimi,

I have chosen Bullzip PDF finally. There are more elaborate codes, I found for this printer. SaveAs dialog has disappered

As far as mail is concerned, I used a different set of code that specifies NTLM parameter also. I first tested it in Excel VBA and then implemented it in macro. it is working fine too

Thanks for continued patient support. We will be in touch. I am going to add you as friend in this forum

Regards,

KSP

Re: Macro to create PDF

Wed, 05 Sep 2012 05:49:28 GMT

Hello kspalani & Omid,

A great discussion indeed.

Can you kindly share the final qv document that is working without displaying any SaveAs dialog box? I am facing the same problem as well. I also have to use "primo pdf" and mail the created pdf file!

Regards,

Rajesh

Re: Macro to create PDF

Thu, 06 Sep 2012 11:06:24 GMT

Hi Rajesh,

For PDF

See http://community.qlik.com/message/211426#211426

This works good in my win 7 64 bit OS for Bullzip Printer, which is also free.

For mail

See code samples attached in text files.

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

Regards,

KSP

Re: Macro to create PDF

soniacoprosa — Fri, 28 Dec 2012 11:06:48 GMT

Por fin me funciona. Muchas gracias.

Re: Macro to create PDF

ysiroong — Thu, 02 May 2013 12:37:08 GMT

I have a question about this as I'm using PDF-XChange as well. How do you pass a variable in as the file name? I had a qvw document set up using the old QlikViewPDF printer. When we moved to Windows Server 2008, that printer no longer worked so I had to install PDF-XChange. The pdf macro we built still works, but the file that is generated only has a generic name (and so it overwrites each copy that is created).

I'd like to be able to pass in a name to save the pdf files as they are being created.

Re: Macro to create PDF

Wed, 05 Jun 2013 13:41:24 GMT

i am new in qlikview so any one can send the link for study Macro. pdf for how use Macro and so ..about

Re: Macro to create PDF

Wed, 26 Jun 2013 13:02:52 GMT

This little bit of functionality is really helpful.

I have included it and it works like a dream.

However ....... Is it possible to loop the vba script so for in the example attached you would create 4 seperate pdf files one for each user ????

If you could this would be genius as I have tried and due to my limited VBA skills have spent more time scratching my head than producing pdfs

One other question I would have is how do you reset the orginal reg settings ? As once you have exicuted the script qv pdf automatically saves everything back to the pdf you set it to in the code and no longer asks you for a directory when saving

Re: Macro to create PDF

Tue, 01 Oct 2013 11:04:10 GMT

Palani K S,

I have requirement to open the pdf documet after clicking on the button, which printer i have to do....?

Is there need to install something..?