Search found 2 matches

by Candu
Mon Jun 30, 2008 9:20 am
Forum: Tutorials
Topic: problem printing multiple Excel sheets
Replies: 3
Views: 4113

<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...
by Candu
Wed Jun 18, 2008 11:25 am
Forum: General
Topic: Excel VBA and doPDF
Replies: 1
Views: 3394

<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...