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
PDF Creation with EXCEL 2002 -> ErrorCode 1004
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.
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.