ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing file name (https://www.excelbanter.com/excel-programming/379700-changing-file-name.html)

Mervyn Thomas

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?



Ron de Bruin

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?




All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com