ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Rename filename.csv (https://www.excelbanter.com/excel-programming/439547-rename-filename-csv.html)

Rob

Rename filename.csv
 
Hi,

I am wanting to use some OpenText code to open a file but the file is
currently named with an CSV extension. Whilst I could go to File Manager
and rename this with a TXT extension, I'd like to do this from within Excel
or create a copy and name it with a TXT extension. Is this possible?

Thanks, Rob



Dave Peterson

Rename filename.csv
 
Look at VBA's help for FileCopy or Name.



Rob wrote:

Hi,

I am wanting to use some OpenText code to open a file but the file is
currently named with an CSV extension. Whilst I could go to File Manager
and rename this with a TXT extension, I'd like to do this from within Excel
or create a copy and name it with a TXT extension. Is this possible?

Thanks, Rob


--

Dave Peterson

Rob

Rename filename.csv
 
Thanks Dave, easy when you know what to look up! Regards, Rob


"Dave Peterson" wrote in message
...
Look at VBA's help for FileCopy or Name.



Rob wrote:

Hi,

I am wanting to use some OpenText code to open a file but the file is
currently named with an CSV extension. Whilst I could go to File Manager
and rename this with a TXT extension, I'd like to do this from within
Excel
or create a copy and name it with a TXT extension. Is this possible?

Thanks, Rob


--

Dave Peterson





All times are GMT +1. The time now is 05:14 AM.

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