Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing file name
I want to change a CSV file name created in excell from myfile.csv to
myfile.txt. I cannot do this directly in excel as it records the name as myfile.txt.csv The reason is that another application wants to have a proper CSV file but with the extension .txt Can you give me a bit ofcode to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing file name
Hi Mervyn
See this page for a example, you can use FileCopy or Name http://www.rondebruin.nl/folder.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mervyn Thomas" wrote in message ... I want to change a CSV file name created in excell from myfile.csv to myfile.txt. I cannot do this directly in excel as it records the name as myfile.txt.csv The reason is that another application wants to have a proper CSV file but with the extension .txt Can you give me a bit ofcode to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update the hyperlink in file after changing the file name | Excel Worksheet Functions | |||
delete info from source file w/out changing the destination file | New Users to Excel | |||
Changing file name | Excel Discussion (Misc queries) | |||
Open Test file with VBA with a changing file number | Excel Programming | |||
Open delimited text file to excel without changing data in that file | Excel Programming |