Saving CSV file with TXT extension

[Mervyn Thomas]

My banking sytem requires a CSV file but having a .TXT filename. I haven't
been able to do this in excel and resorted to doing a rename outside of
excel. Does anyone know how to do this or to write a macro that can do it
within excel? Using Excel 2000

 

[RichardSchollar]

Hi Mervyn

If have the filename and path of your csv file (eg "C:\Test.csv" for
the sake of argument) you can easily rename it to .txt within Excel VBA
by using the Name command:

Name "C:\Test.csv" As "C:\Test.txt"

which will rename your file.

Hope this helps!

Richard