http://www.dopdf.com/forum/ Discussion forum for doPDF users. en Thu, 09 Feb 2012 08:02:46 +0000 http://www.dopdf.com/forum/topic/excel-vba-and-dopdf#post-95 Wed, 18 Jun 2008 07:50:01 +0000 Softland 95@http://www.dopdf.com/forum/ <p>Sorry but not from the code directly. Normally another parameter should set the name automatically, <strong>prtofilename:="c:\test.pdf"</strong>, but since that also requires to set a path it's not supported (it would mean bypassing the save as window).</p> <p>However, note that doPDF always prints the pdf with a filename that's actually the name of the opened workbook, so you'll simply have to name your workbook the way you want it shown in the PDF. </p> http://www.dopdf.com/forum/topic/excel-vba-and-dopdf#post-94 Wed, 18 Jun 2008 07:25:59 +0000 Candu 94@http://www.dopdf.com/forum/ <p>I am very impressed with doPDF. I am adept at Excel &#38; 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 /> ActiveWindow.SelectedSheets.PrintOut copies:=1, Collate:=True </p> <p>This works fine but I'd like to populate the name field. </p>