| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
| SaveAs Filename:=filename, FileFormat:=xlCSV | Excel Programming | |||
| Converting a Variable Filename to a Constant Filename | Excel Programming | |||
| set filename to <filename-date on open | Excel Worksheet Functions | |||
| How do i auto rename a worksheet to be the same filename as save f | Excel Worksheet Functions | |||
Linear Mode
