| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print to Adobe Acrobat (2 ws to one file)
I would like a macro that would print 2 or 3certain worksheets from a
workbook to Adobe and print them to one acrobat file and name it something based on a cell in the current worksheet. Does anyone know how to begin doing this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print to Adobe Acrobat (2 ws to one file)
Does your version of Excel have the Acrobat add-in installed? If so, just
record a macro and see what you get. What I got was: Application.ActivePrinter = "Acrobat PDFWriter on LPT1:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Acrobat PDFWriter on LPT1:" -- Vasant "Michael McClellan" wrote in message om... I would like a macro that would print 2 or 3certain worksheets from a workbook to Adobe and print them to one acrobat file and name it something based on a cell in the current worksheet. Does anyone know how to begin doing this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print to Adobe Acrobat (2 ws to one file)
hi,
you can print something in pdf using the following command AcrobatPDFMaker.AutoExecNew.ConvertToPDFA in the VBA. Before you have to add the necessary reference : in the VB... tools... select AcrobatPDFMaker and thats it, julien (Michael McClellan) wrote in message . com... I would like a macro that would print 2 or 3certain worksheets from a workbook to Adobe and print them to one acrobat file and name it something based on a cell in the current worksheet. Does anyone know how to begin doing this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fail to link a pdf file in excel 2003 with Adobe Acrobat 7.0 Prof | Excel Discussion (Misc queries) | |||
| can't print to adobe acrobat | Charts and Charting in Excel | |||
| Adobe Acrobat | Excel Discussion (Misc queries) | |||
| how to re install Adobe Acrobat in Excel? The adobe Acrobat work. | Excel Discussion (Misc queries) | |||
| PrintOut with Adobe Acrobat 6.0 | Excel Programming | |||
Linear Mode
