PDFing an Excel Workbook
I'm trying to print selected Excel sheets to Acrobat
Distiller, with an instruction of where to save it.
This line creates a pdf file in the right place, but it
can't be opened by Acrobat.
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:="Acrobat Distiller on Ne08:",
PrToFileName:="c:\myFiles\test.pdf"
This line creates a pdf file that is perfect, but I have
press the save button on the dialog box myself.
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:="Acrobat Distiller on Ne08:",
Can someone tell me how to make the first command work so
that I can print 90 files without having to hit Save 90
times? (I know I've asked this before, but was not able
to implement the answer satisfactorily).
Thanks
Daniel
|