View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Problems with Printout Method

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