Rename .txt file with macro

[markjhunter]

Sorry about this rather simple question everyone but I have only jus
stated working with Excel!!

I need to rename an existing .txt file to a .xml file. The file wil
always be in the same directory on the pc, is this possible with cod
in a macro?

 

[HotRod]

IF you want something simple try the shell command and then "rename
c:\filename.txt c:\filename.xml"

 

[crispbd]

The following code allows you to change a filename, make sure and adjus
the
directory location / filename before running.

OldName = "C:\test.txt": NewName = "C:\test.xml"
Name OldName As NewNam

 

[Stephen Bullen]

Hi Markjhunter,

I need to rename an existing .txt file to a .xml file. The file will
always be in the same directory on the pc, is this possible with code
in a macro??

Sure, it's the Name command:

Name OldFile, NewFile

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk