View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Used to be possible in Excel97

That's the code to use . Check the help for the Name statement.
Name "C:\Oldfile.txt" As "C:\NewFile.txt"

NickHK

"Albert" wrote in message
...
I don't get it.

"NickHK" wrote:

Albert,
Name "OldFile" As "NewFile"

NickHK

"Albert" wrote in message
...
Hi.
Is there any way of renaming files through VBA with Excel XP?
I remember it used to be possible with previous versions.
Best regards,
Albert C