View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Bonallack[_2_] Daniel Bonallack[_2_] is offline
external usenet poster
 
Posts: 27
Default 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