| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert multiple sheets into PDF
hi,
i have some code to convert multiple sheets to PDF. i can get up to 3 sheets into one PDF file, but when i do anything more than that it only prints the last sheet selected instead of all of them. here is my sample: Sheets(Array("VGA Summary", "1Q Test", "1N Test")).Select ActiveWindow.SelectedSheets.PrintOut , ActivePrinter:="PDFCreator" i would like to add more sheet names to the array, but when i do it wont work. thanks in advance, geebee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
| Convert multiple excel files with multiple sheets to PDF - how? | Excel Discussion (Misc queries) | |||
| Excel Convert Multiple Rows into Multiple Columns | Excel Programming | |||
| Excel Convert Multiple Rows into Multiple Columns | Excel Worksheet Functions | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
Threaded Mode
