Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PDFing an Excel Workbook
Dan,
The problem is that you cannot specify via Excel where to create the PDF file. That PRtoFileName parameter is actually creating a postscript file. That's the reason Acrobat can't read it. If you don't to be prompted for a filename you must set this option via the printing preference of the Acrobat Distiller printer or Acrobat PDF printer depending on the version of Acrobat you have. By default "prompt for filename" is checked. If you uncheck this it will print to the logged on user's desktop. If you wish you print to a very specific location, then you need to create a new port for the Acrobat printer. By default the port points to C:\documents and settings\all users\desktop. Again change this under the PDF printer's properties. -Tim -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) |