Output to CSV

[sanjay]

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

 

[Tom Ogilvy]

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