Problems with Printing to PDF using VBA...

[hollifd]

I am using the following code to print a pdf file:

ActiveWindow.SelectedSheets.PrintOut ActivePrinter:="_PDF WRITER on Ne00:", PrintToFile:=True, Collate:=True, PrToFileName:="C:\Temp\Sample1.pdf"

When I try to open the PDF file that was created with this code, I get an error that states:

Adobe Reader could not open Sample1.pdf because it is either not a supported file type or the file has been damaged.

When I manually print the sheet and choose the PDF writer and select a filename, everthing works fine.

Does anyone have some items for me to look at for solving this problem?

Thanks,

David

 

[hollifd]

More Information...

I can use sendkeys to fill out the path and filename on the PDF Writer window that appears when running the following code and everything works OK. I would prefer to not use SendKeys if at all avoidable since I am not really that knowledgeable about SendKeys.

ActiveWindow.Selectedsheets.PrintOut  ActivePrinter:="_PDF WRITER on Ne00:"

Only when I try to specify the PrintToFile and PrToFileName paramters using VBA does the PDF file get corrupted so that it cannot be opened.

Still looking for any and all ideas.

Thanks,

David

 

[Juan Pablo González]

One of the board´s users posted this a while ago:

http://www.mrexcel.com/board2/viewtopic.php?t=119332

 

[hollifd]

Thanks Juan Pablo González,

Yes. I saw that too.

I have found another PDF writer printer option that is on our company's system and it seems to work correctly with this code:

ActiveWindow.SelectedSheets.PrintOut ActivePrinter:="\\srv2Win2PDF", PrintToFile:=True, PrToFileName:="C:\Temp\Dummy.pdf"

The PDF writer that I am now using is WIN2PDF.

Thanks again for the help.

David