<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have an Excel workbook with the sheet 'data'. I would like to create a macro to export this as a new .xlsx file to:<br />
c:\temp<br />
And to name the file: &quot;webleads_&quot;&amp;TEXT(NOW(),&quot;dd<wbr />Mmmyy&quot;)&quot;<br />
<br />
What's the best way of coding this in a macro?<br />
<br />
Cheers.
</div>
</div>


Hi,

I have an Excel workbook with the sheet 'data'. I would like to create a macro to export this as a new .xlsx file to:
c:\temp
And to name the file: "webleads_"&TEXT(NOW(),"ddMmmyy")"

What's the best way of coding this in a macro?

Cheers.

Excel: Macro export to new .xlsx file

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