PDF Creation with EXCEL 2002 -> ErrorCode 1004

[Andi]

Hi

I want to create a PDF File from EXCEL with the following VBA-Script:

Sub doPrint()
Dim PDF As New CDIntfEx.CDIntfEx

With PDF
.DriverInit ("Amyuni PDF Converter")
.SetDefaultPrinter
.DefaultFileName = "C:\temp\test.PDF"
.FileNameOptions = 3

Worksheets("Auswertung").PrintOut
Range("A1").Select

.DriverEnd
End With

End Sub

I allways get the error message 1004 (German: Fehler beim Ausdruck auf PDF Converter...).

If I print the EXCEL sheet first manually to the PDF converter, then my script also works.

When I use this script in ACCESS, then I've also no problems.

Our software versions:
Windows 2000 SP4
EXCEL 2002 SP3 (Office XP SP3)
PDF Converter 2.10a

My script doesn't work on alle company pcs.

I hope somebody can help me
Andi

[Joan]

Hello,

Are you calling EnablePrinter() when catching the EnablePre() event generated by the driver?

If not please call EnablePrinter() right beforecalling:
Worksheets("Auswertung").PrintOut

Please note that 2.10a is relatively a little bit old. Our latest version is 2.10i-8, if you have a maintenance plan please feel free to download the latest version from: http://www.amyuni.com/en/support/updates.html

Hope this helps.