| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you print format multiple sheets in excel at once? | Excel Discussion (Misc queries) | |||
| Print Multiple Sheets to PDF Problem | Excel Discussion (Misc queries) | |||
| Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
| how to print multiple work sheets using vba | Excel Discussion (Misc queries) | |||
| Print multiple excel sheets in color | Setting up and Configuration of Excel | |||
Threaded Mode
