Change FILE FORMAT

[scottie1]

Hi folks

I'm trying to work out how to change the open CSV file to Excel and then save it as the same file name,

 

[PHV]

Take a look at the SaveAs method.

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

 

[scottie1]

I dont think I explained it very well, really what I need to do is open up a folder with all the CSV files and be able to save them exactly the same but as XLS file. I dont really want to open them all up individually and go through the moves of saving to XLS.

 

[strongm]

Given that we are in the VBA forum, I suspect that PHV was intimating that you could use a program that uses the SaveAs method to automate the conversion; you don't have to do it manually...

 

[PHV]

In VBA for excel, take a look at the Dir function (something like x=Dir("*.csv"), use the F1 key to get examples), and at the Workbooks.Open and ActiveWorkbook.SaveAs methods.

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