<div>
Thanks for the response.<br />
Apart from the backslash after the word &quot;Documents&quot; it isn't really that much different, but I'm afraid it still throws up an error.I'm using Excel 2010 if that's significant.
</div>


Thanks for the response.
Apart from the backslash after the word "Documents" it isn't really that much different, but I'm afraid it still throws up an error.I'm using Excel 2010 if that's significant.

<div>
Hi,<br />
I managed to work around the error. I simplified the string expression in F1 (made it shorter really) and it worked fine.<br />
Thanks for your time
</div>


Hi,
I managed to work around the error. I simplified the string expression in F1 (made it shorter really) and it worked fine.
Thanks for your time

<div>
<div class="content wysiwyg-content">
Hi<br />
I'm trying to export a range from an excel spreadsheet to My Documents in PDF format.<br />
The range contains a number of charts. I have tried a few variations of the following code to no avail;<br />
<br />
Range(&quot;SummaryChart&quot;).Expo<wbr />rtAsFixedF<wbr />ormat 0, &quot;C:\Documents&quot; &amp;&nbsp;Range(&quot;F1&quot;).Value &amp;&nbsp;&quot;.pdf&quot;, 0<br />
<br />
(Range F1 contains the name I would like the file to be named as)<br />
Any advice is appreciated.<br />
Thanks
</div>
</div>


Hi
I'm trying to export a range from an excel spreadsheet to My Documents in PDF format.
The range contains a number of charts. I have tried a few variations of the following code to no avail;

Range("SummaryChart").ExportAsFixedFormat 0, "C:\Documents" & Range("F1").Value & ".pdf", 0

(Range F1 contains the name I would like the file to be named as)
Any advice is appreciated.
Thanks

Excel range to PDF

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