Excel to csv?

[Mark M]

I know you can go to file>save as then select format but is there anything I could do so its basically a click of a button? MAcro perhaps? If so any pointers would be really helpfull!

I know it doesnt take that long to save as a csv but Im going to be doing it on potentially hundreds of files.

Thanks, Mark

 

[Cobertizo]

http://www.softinterface.com/Convert-XLS/Features/Convert-CSV-To-XLS.htm ? Haven't tried it, but looks promising and seems to be free...

 

[suarve]

Can't you literally just record yourself saving a file as a csv. Can't imagine there'd be too much code to change.

EDIT: looks like you could, have just recorded myself in office 2007.

    ActiveWorkbook.SaveAs Filename:= _
        "C:\meh\filename.csv", _
        FileFormat:=xlCSVMSDOS, CreateBackup:=False

COuld make a few variables in the name, so its saved with the current date if u like too.