Search found 2 matches
Search found 2 matches • Page 1 of 1
- Mon Jun 30, 2008 9:20 am
- Forum: Tutorials
- Topic: problem printing multiple Excel sheets
- Replies: 3
- Views: 4157
<t>I can select multiple sheets in Excel and print to a multi-page PDF.<br/> This works in most cases but in other cases doPDF will only print 1 sheet per PDF file and give me the "Save PDF" pop up on each sheet.<br/> I can't find any rhyme or reason for it except that it mainly throws this on new s...
<t>I am very impressed with doPDF. I am adept at Excel & VBA macros but can't figure out if/how I can pre-populate the PDF filename in the pop-up box. Is this possible?<br/> I am changing the printer to doPDF then running:<br/> Sheets(Array("sheet1", "sheet4", "sheet6")).Select<br/> <br/> Active...