Problems using PDF converter to convert Excel to PDF

[tnguyen]

I am receiving the following error when trying to convert an excel spreadsheet to PDF ("PDF Producer" is the name of the printer).

Your file could not be printed due to an error on PDF Producer on LPT1:. There are several possible reasons:

• There may not be enough memory available. Try closing files and programs you aren't using.
• If you use a network for printing, there may be a problem with the network connection or the printer driver.
• There may be loose cables or a bad connection between your computer and printer.

For more information about troubleshooting printing problems, click Help.

I initially created a test application in vb6 (using excel automation), that worked fine. When I attempted to add the code to our production software, I receieved errors. After that I was unable to do the conversion in my test application. I then tried running the code in technical note 5 (Access application) which worked fine. So I tried converting to PDF using VBA code from within an excel spreadsheet and that didn't work. It seems like the problem has something to do with excel connecting to the PDF printer.

Has anyone else had this problem... Any ideas.
Any help is appreciated.

Thanks,
Thach

[Joan]

Hello,

Are you calling EnablePrinter() right before the Printout command of Excel?

[tnguyen]

Yes, I am calling EnablePrinter() just before Printout. This was something that worked at one point in test code. For some strange reason Excel is now having problems with the PDF printer. I've tried uninstalling and reinstalling the printer and have not had any luck. I also wrote some VBA code in a Word document to test and that worked without any problem.

It seems that only Excel is having problems using the PDF printer, since I was able to create PDF's from MS Word, and MS Access.

If anybody has any ideas on troubleshooting this, please let me know your thoughts, as I am all out of ideas.

Should also mention I am using Office 2000 SP3.

Thanks.

[tnguyen]

I finally figured out the problem.

The spreadsheet I was trying to convert was set to a non standard papersize. It seems as if one of the laser printers installed on my machine created an 8.5x11 paper size separate from the standard windows letter size. When the excel spreadsheet was set to this papersize I got the error. When I changed it to Worksheet.PageSetup.PaperSize = xlPaperLetter or any of the many other excel defined paper size constants it worked fine.

Hope this helps anyone else with a similar problem.