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: 2854
<p>I can select multiple sheets in Excel and print to a multi-page PDF.</p> <p>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.</p> <p>I can't find any rhyme or reason for it except that it mainly throws this on n...
<p>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?</p> <p>I am changing the printer to doPDF then running:</p> <p>Sheets(Array("sheet1", "sheet4", "sheet6")).Select<br /> ActiveW...