<div>
Is there data beyond column G that you don't want copying?<br />
<br />
If not then you can just copy the sheet and save as csv, rather than creating a new sheet and copying and pasting data to it. Copying some of Flyster's suggestion:<br />
<br />

<pre><code id="code-20-40618618-1">Sheets(&quot;Sheet1&quot;).Copy
fn = Format(Now(), &quot;yyyymmddhmmss&quot;)
ActiveWorkbook.SaveAs Filename:=&quot;C:\Temp\&quot; &amp; fn &amp; &quot;.csv&quot;, FileFormat:=xlCSV, _
        CreateBackup:=False</code></pre>
<br />
Thanks<br />
Rob
</div>


Is there data beyond column G that you don't want copying?

If not then you can just copy the sheet and save as csv, rather than creating a new sheet and copying and pasting data to it. Copying some of Flyster's suggestion:



Sheets("Sheet1").Copy
fn = Format(Now(), "yyyymmddhmmss")
ActiveWorkbook.SaveAs Filename:="C:\Temp\" & fn & ".csv", FileFormat:=xlCSV, _
        CreateBackup:=False


Thanks
Rob

<div>
Is there a way to close the new sheet once it is saved automaically. &nbsp;I tried a couple of ways and I could not get it to work. <br />
<br />
The rest of the code works great!! Will award points for above.
</div>


Is there a way to close the new sheet once it is saved automaically.  I tried a couple of ways and I could not get it to work.

The rest of the code works great!! Will award points for above.

<div>
Just add:<br />
<br />
ActiveWorkbook.Close
</div>


<div>
Used &nbsp;ActiveWorkbook.Close Savechanges:=False at the end to close the sheet, works GREAT!
</div>


Used  ActiveWorkbook.Close Savechanges:=False at the end to close the sheet, works GREAT!

<div>
<div class="content wysiwyg-content">
I need a macro that will export all data from A3 to G3 all the way down to the last record with data and export this to C:\temp. The name of file needs to be the date in yyyymmddhmmss <br />
<br />
Any help would be GREAT!
</div>
</div>


I need a macro that will export all data from A3 to G3 all the way down to the last record with data and export this to C:\temp. The name of file needs to be the date in yyyymmddhmmss 

Any help would be GREAT!

Excel Macro export populated records to CSV file with time and date as name

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