<div>
the core of the code is here:<br />
<br />

<pre><code id="code-20-39972384-1">   strFileName = inputbox(&quot;File path?&quot;)
    ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        strFileName _
        , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=True</code></pre>
</div>


the core of the code is here:



   strFileName = inputbox("File path?")
    ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        strFileName _
        , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=True

<div>
The work flow would be:<br />
1. optional - Copy the named ranges to one worksheet<br />
2. Save the worksheet/workbook as PDF (no need for third-party components)
</div>


The work flow would be:
1. optional - Copy the named ranges to one worksheet
2. Save the worksheet/workbook as PDF (no need for third-party components)

<div>
Thanks that helped a lot.<br />
It is really convenient.<br />
I can select all the sheets I want to print and then just go save them all together in one pdf.<br />
I recorded a macro and that worked fine.<br />
I will figure out the rest of the code.
</div>


Thanks that helped a lot.
It is really convenient.
I can select all the sheets I want to print and then just go save them all together in one pdf.
I recorded a macro and that worked fine.
I will figure out the rest of the code.

<div>
<div class="content wysiwyg-content">
I have an Excel 2010 workbook with 9 worksheets. <br />
<br />
7 of the worksheets each contains a report in a named range on it.<br />
<br />
I want to print these reports either individually or <b>preferrably together in one pdf</b> and then save to a given directory using VBA. Before creating any pdf I will use VBA to assign a unique name to it. <br />
<br />
I normally use PDFCreator for printing to pdf format, but I will use whatever can do my task well.<br />
<br />
Do you have a solution please.
</div>
</div>


I have an Excel 2010 workbook with 9 worksheets. 

7 of the worksheets each contains a report in a named range on it.

I want to print these reports either individually or preferrably together in one pdf and then save to a given directory using VBA. Before creating any pdf I will use VBA to assign a unique name to it. 

I normally use PDFCreator for printing to pdf format, but I will use whatever can do my task well.

Do you have a solution please.

VBA to Print from Excel 2010 to pdf to a given path with a given filename.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.