Set up Macro to export as CSV file

**bconner** · 04-13-2009, 03:07 PM

I need to set up a Macro in excel that will take range ("a1:f16") and export as a CSV file, how do I do this?

**Kenneth Hobson** · 04-13-2009, 03:30 PM

Record a macro. Then copy the range, open a blank xls, and then File > SaveAs and pick the CSV format.

**bconner** · 04-13-2009, 03:58 PM

Thank you Mr. Hobson

**Chance2** · 04-13-2009, 04:44 PM

If you are looking for code to do this, then this might work...

Please Login or Register  to view this content.

**sysadmin** · 03-07-2011, 12:55 PM

Hi There,

sorry to jump on an old post, ive found this post and i am looking to use this macro to export a worksheet to csv which works great however it seems to add a blank line to the end of the CSV file which i need to find a way to stop it from doing this as the blank line corrupts the import of the file in the program im trying to get the data into.

thanks in advance