Saving CSV file with TXT extension
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
Mervyn Thomas wrote:
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
|