Output to CSV
 

Hi,

Is there a way to create a macro to export a value (or even
worksheet) to a csv file.


I tried by creating a macro to save as a csv but this copies an
converts the current workbook to the new file type etc.

Any help would be welcome

--
Message posted from http://www.ExcelForum.com

Output to CSV
 

It doesn't convert the source workbook unless you saveas with the same file
name. However,

You could always copy your sheet as a new workbook, saveas CSV, then close
it.

Activesheet.copy
Activeworkbook.Saves "C:\Myfolder\Myfile.csv", FileFormat:=xlCSV
Activeworkbook.close SaveChanges:=False

--
Regards,
Tom Ogilvy


sanjay wrote in message
...
Hi,

Is there a way to create a macro to export a value (or even a
worksheet) to a csv file.


I tried by creating a macro to save as a csv but this copies and
converts the current workbook to the new file type etc.

Any help would be welcome.


---
Message posted from http://www.ExcelForum.com/