Create CSV as TXT file

[JazzSP8]

Hey All

I'm trying to use VBA in Excel 2003 to export a file as a CSV but with a TXT file extension.

So after some messing about I came to the conclusion that the best idea would be to create the CSV file as I normally would do and then simply rename the ".csv" as ".txt" which I can do no problem in DOS but I'd like to finish the job properly in the Macro.

Only problem being I don't have a clue how to do that from within VBA

Ideally if someone could point me in the right direction of the VBA equivalent of the DOS

ren *.csv *.txt

that would be great

Thanks in advance for any help that can be provided.

 

[Richard Schollar]

You are looking for the Name statement ie:

Name Fullname&Path As NewFullName&Path

'eg:

Name "C:\SomeFolder\myTextFile.csv" As "C:\SomeFolder\myTextFile.txt"

EDIT: If you have more than one file, you need to loop thru the files doing each one individually.

 

[JazzSP8]

Ha! - So simple when you put it like that Richard!

I'd got NO idea that 'Name' existed LOL

Thanks a lot for the quick reply