Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving CSV file with TXT extension
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel file not saving properly | Excel Discussion (Misc queries) | |||
problem saving csv file | Excel Discussion (Misc queries) | |||
saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
saving file as text(tab delimited)... | Excel Discussion (Misc queries) | |||
I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) |