change file format

[scottie1]

Hi Folks

i have a load of CSV files in my C:\drive but i want to run a macro in excel to change the file formats to XLS. Then put them in a folder called C:\adam

 

[PHV]

Have you tried the macro recorder ?
Then you can take a look at the Dir function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dyarwood]

You will need to import the data into a new spreadsheet. Then save with the name of the CSV file. I suggest you have a play with the macro record button and save the macro into a personal workbook?