File Saving Macro?

Posted by Chris on October 19, 2001 5:38 AM

Does anyone know of a macro that will open all the files in a directory and change the file extension?
I have a directory of about 200 files all called "file".xls and I want to save them all as file.csv
note the quotation marks that need to be eliminated from the file name.

Many thanks to anyone who can help!

Posted by Barrie Davidson on October 19, 2001 6:52 AM

Chris, if you want to convert these files to CSV format, have a look at

http://ca.geocities.com/b_davidso/Web_Page_Files/excel_vba.html

I had a question just like this (question was: I have a folder full of .xls files(400+) which need to be converted to .csv files. How do I do this (renaming the extension in Explorer doesn't have the required effect)? I don't want to open 1 by 1, is their a macro code???? )

Regards,
BarrieBarrie Davidson