I have a macro that selects and prints a chart.
When I do a "Record Macro" and tell it to print using PDF995, I get a good PDF file.
When I use :
Copies:=1, Collate:=True, PrToFileName:="c:\Zaas\dir
1.pdf", the pdf file is three times bigger and won't open.
The error message says either the file's an incompatable format or it's corrupted.
I'd appreciate any help.
' Dir1 Macro
' Macro recorded 10/23/2008 by tmccar10
ActiveWindow.Visible = False
Application.ActivePrinter = "PDF995 on Ne00:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, PrToFileName:="c:\Zaas\dir1.pdf"