Print to Adobe Acrobat (2 ws to one file)

  • Thread starter Michael McClellan
  • Start date
M

Michael McClellan

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?
 
V

Vasant Nanavati

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:"
 
J

julien

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
 
Top