topic Macro Print PDF fails when turns in 64 bit computer in QlikView

Macro Print PDF fails when turns in 64 bit computer

marcel_olmo — Thu, 17 Feb 2011 19:30:57 GMT

Hey guy, recently I've made a macro to print pdf reports with Bullzip.

I've ben executing the macro in QV 10 wiith 32 bit and windows XP. Everything was fine.

Now, I'm working in QV 10 64 bit in Windows 7 and I can't make it work.

Here you have the function that prints the pdf :

//prints the pdf with the bullzip printer

FUNCTION MyPrintPDFWithBullZip (pdfOutputFile)
set obj = CreateObject("Bullzip.PDFPrinterSettings")
obj.SetValue "Output" , pdfOutputFile
obj.SetValue "ConfirmOverwrite", "no"
obj.SetValue "ShowSaveAS", "never"
obj.SetValue "ShowSettings", "never"
obj.SetValue "ShowPDF", "no"
obj.SetValue "RememberLastFileName", "no"
obj.SetValue "RememberLastFolderName", "no"
obj.SetValue "ShowProgressFinished", "no"
obj.SetValue "ShowProgress", "no"
obj.WriteSettings True
END FUNCTION

And my error is :

ActiveX component can't create object: 'Bullzip.PDFPrinterSettings'

Any help or ideas would be appreciated.

Regards!!

Macro Print PDF fails when turns in 64 bit computer

tseebach — Sat, 19 Mar 2011 20:36:01 GMT

Make sure you have set Allow System Access in the macro module

Macro Print PDF fails when turns in 64 bit computer

marcel_olmo — Mon, 21 Mar 2011 10:34:33 GMT

Thanks Torben for your interest.

In fact, this is the first thing I usually do when I have a problem with a macro.

I found the solution and it was posted here :

http://community.qlik.com/forums/t/16003.aspx?PageIndex=2

Many thanks anyway!!

Cheers!

Macro Print PDF fails when turns in 64 bit computer

tduarte — Fri, 24 Jun 2011 09:02:05 GMT

Hi Marcel,

I'm having problems running the create pfd marcro on Windows Server 2008 but the link you posted no longer exists.

Could you share the solution?

Thanks.

marcel.olmo1 wrote:
Thanks Torben for your interest.
In fact, this is the first thing I usually do when I have a problem with a macro.
I found the solution and it was posted here :
http://community.qlik.com/forums/t/16003.aspx?PageIndex=2
Many thanks anyway!!
Cheers!

Macro Print PDF fails when turns in 64 bit computer

bm59 — Mon, 02 Apr 2012 10:22:29 GMT

Hi,

I have the same problem on 64bits, the link is broken, can you explain the trick to figure out ?

Thx

Macro Print PDF fails when turns in 64 bit computer

Tue, 17 Apr 2012 15:08:05 GMT

Hi BM59

I have the same problem, I can run the Macro with QV 32bits but when I try made same Macro in QV 64 bits is when apppear this same error.

If you found the solution for this problem, Can you help me? =l

Thanks

Re: Macro Print PDF fails when turns in 64 bit computer

bm59 — Tue, 17 Apr 2012 16:05:14 GMT

Hi Hugo,

In the MyPrintPDFWithBullZip fonction.

Replace:

set obj = CreateObject("Bullzip.PDFPrinterSettings")
By:

set obj = CreateObject("Bullzip.PdfSettings")

work for me

Macro Print PDF fails when turns in 64 bit computer

Tue, 17 Apr 2012 16:34:16 GMT

First thanks for your help 😃

I used this CreateObject("Bullzip.PdfSettings") this working, I mean is not appear the message ActiveX component can't create object:

But...Now appear this messager:

The PrinterName property must be set before calling the GetSettingsFilePath method. Please If you have time, can you help me?

Sub pagos
' ActiveDocument.reload
vReport = "RP01" 'Set report
vName = "Pagos" 'Name of output pdf
ActiveDocument.PrintReport(vReport), "Bullzip PDF Printer", false 'Printreport
reportFile = "C:\" & vName &".pdf" 'Setting outputname
MyPrintPDFWithBullZip(reportFile) 'Call pdf printer
ActiveDocument.GetApplication.Sleep 5000
' mailrapport
' ActiveDocument.S
ActiveDocument.GetApplication.Sleep 5000
ActiveDocument.GetApplication.Quit
End sub

FUNCTION MyPrintPDFWithBullZip (pdfOutputFile)

set obj = CreateObject("Bullzip.PdfSettings")
obj.SetValue "Output" , pdfOutputFile
obj.SetValue "ConfirmOverwrite", "no"
obj.SetValue "ShowSaveAS", "never"
obj.SetValue "ShowSettings", "never"
obj.SetValue "ShowPDF", "no"
obj.SetValue "RememberLastFileName", "no"
obj.SetValue "RememberLastFolderName", "no"
obj.SetValue "ShowProgressFinished", "no"
obj.SetValue "ShowProgress", "no"
obj.WriteSettings True

END FUNCTION

Macro Print PDF fails when turns in 64 bit computer

Wed, 18 Apr 2012 10:55:38 GMT

Hi,

Try this

it worked for me

FUNCTION MyPrintPDFWithBullZip (pdfOutputFile)

Set obj_printer_util = CreateObject("Bullzip.PDFUtil")

printername = obj_printer_util.defaultprintername

set obj = CreateObject("Bullzip.PdfSettings")

obj.printername = obj_printer_util.defaultprintername

obj.SetValue "Output" , pdfOutputFile

obj.SetValue "ConfirmOverwrite", "no"

obj.SetValue "ShowSaveAS", "never"

obj.SetValue "ShowSettings", "never"

obj.SetValue "ShowPDF", "no"

obj.SetValue "RememberLastFileName", "no"

obj.SetValue "RememberLastFolderName", "no"

obj.SetValue "ShowProgressFinished", "no"

obj.SetValue "ShowProgress", "no"

obj.WriteSettings True

END FUNCTION

Macro Print PDF fails when turns in 64 bit computer

bm59 — Wed, 18 Apr 2012 11:18:27 GMT

it's ok for you, now?

Macro Print PDF fails when turns in 64 bit computer

Wed, 18 Apr 2012 22:18:44 GMT

Yes is working with this script!!!!

Is important you know...
I made diferents experiment and I found other a solution temporary, is only copy Qv,exe(x86) in a folder special in the server 64bits after that, I opened file qvw and I used the macro.
I know is thats is crazy but also this worked =s

But ... I going to use this script is more easy 😃

Thanks for help me

Macro Print PDF fails when turns in 64 bit computer

Thu, 19 Apr 2012 08:47:29 GMT

Hi,

Try this

it worked for me

FUNCTION MyPrintPDFWithBullZip (pdfOutputFile)

Set obj_printer_util = CreateObject("Bullzip.PDFUtil")

printername = obj_printer_util.defaultprintername

set obj = CreateObject("Bullzip.PdfSettings")

obj.printername = obj_printer_util.defaultprintername

obj.SetValue "Output" , pdfOutputFile

obj.SetValue "ConfirmOverwrite", "no"

obj.SetValue "ShowSaveAS", "never"

obj.SetValue "ShowSettings", "never"

obj.SetValue "ShowPDF", "no"

obj.SetValue "RememberLastFileName", "no"

obj.SetValue "RememberLastFolderName", "no"

obj.SetValue "ShowProgressFinished", "no"

obj.SetValue "ShowProgress", "no"

obj.WriteSettings True

END FUNCTION

Macro Print PDF fails when turns in 64 bit computer

Thu, 19 Apr 2012 14:59:32 GMT

Hi David !

Yes is working with this script you share me 😃

Now I use this script for the new develop model of QV.
Thanks for your help and time you take for respond.

Thanks

Re: Macro Print PDF fails when turns in 64 bit computer

Mon, 03 Sep 2012 13:05:17 GMT

Thanks Dave. Finally your magic code worked for me. I use Windows 7 Professional 64bit and Bullzip PDF printer.

Re: Macro Print PDF fails when turns in 64 bit computer

Anonymous — Wed, 08 Jan 2014 14:39:48 GMT

Hi David,

Thanks, this script works fine for me.

There's only one problem left.

Although I checked "ShowPDF", "no", it stills asks me if I want to open the generated document. This message keeps waiting and stucks the printing of the PDF document. I want the message to be supressed, so this process can run fully automaticly.

Do you have any advice for me?

Thanks in advance.

Kind regards,

Henco

Re: Macro Print PDF fails when turns in 64 bit computer

Wed, 09 Apr 2014 09:31:38 GMT

The solution: set obj = CreateObject("Bullzip.PdfSettings") worked also for me!

Re: Macro Print PDF fails when turns in 64 bit computer

ThornOfCrowns — Wed, 09 Apr 2014 09:34:07 GMT

You're replying to a two year old thread.