Print Multiple Sheets
 

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

Print Multiple Sheets
 

On Mon, 4 Aug 2003 04:31:45 -0400, RogerM wrote:

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

Print Multiple Sheets
 

Hi Sander,

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

Thanks,
Roger
"Sander Lablans" wrote in message
...
On Mon, 4 Aug 2003 04:31:45 -0400, RogerM wrote:

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