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?

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?

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?