Print Multiple Sheets

[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

 

[Sander Lablans]

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

 

[RogerM]

Hi Sander,

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

Thanks,
Roger