ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problems with Printout Method (https://www.excelbanter.com/excel-programming/324494-problems-printout-method.html)

No Name

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



All times are GMT +1. The time now is 07:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com