Problems with Printout Method

G

Guest

Hi,
I am trying to use PrintOut methos to save an excel file
to pdf file and It creates file which I cannot open .

code is

Sheets(Array("009_report")).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
Collate:=True, PrintToFile:=True, ActivePrinter:="Acrobat
Distiller on Ne00:", prToFileName:="c:\test.pdf"

it actually saves file there but I cannot open that file
can someone pls help.

I really appreciate your help
Jagan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating PDF files via 995 1
Print to PDF format 4
Automated Print from Excel to PDF 2
Print to PDF using PDF-XChange 3.0 2
Print To pdf Not Working 5
issues with getting .pdfs to be created 3
Print Spreadsheet to PDF file 1
PrintToFile - PDF Issue 0

Top