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/