Print Multiple Sheets

  • Thread starter Thread starter RogerM
  • Start date Start date
R

RogerM

I would like to print several sheets of a workbook to a single file via PDF
Writer. This I can do manually by selecting all the sheets prior to
printing. I would like to automate this using VBA but there are two steps I
am having difficulty with:

1. How do I select multiple sheets for printing?
2. How do I send the file name to PDF Writer so that I don't have to
respond to it's Save As dialog? Do I have to use a Sendkeys approach?


Thanks,
Roger
 
I would like to print several sheets of a workbook to a single file via PDF
Writer. This I can do manually by selecting all the sheets prior to
printing. I would like to automate this using VBA but there are two steps I
am having difficulty with:

1. How do I select multiple sheets for printing?
2. How do I send the file name to PDF Writer so that I don't have to
respond to it's Save As dialog? Do I have to use a Sendkeys approach?


Thanks,
Roger

Solution to Question number 1:

Sheets(Array("Sheet1", "Sheet3")).Select

Probably enough for you to make this work. (You should use the 'record
macro' button sometimes. Quite useful.)
Not sure on Q2 though...

SL
 
Hi Sander,

Thanks for the tip, especially about the "Record Macro Button" something I
had completely forgotten.

Thanks,
Roger
 
Back
Top