Print to Adobe Acrobat (2 ws to one file)

  • Thread starter Thread starter Michael McClellan
  • Start date 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?
 
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:"
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Adobe save file prompt 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Print to PDF 2
Select and rows to another cell if one of the cells contains data 2
Print to PDF using Adobe Acrobat 6.0 2
Print to PDF with Acrobat 7.0 5
PrintOut with Adobe Acrobat 6.0 1
Code to Run PDF Maker 1

Back
Top