changing file name

[walid66]

Is there a way to change the file name in the directory before it is open?
For example, the file that I have now named Sites.xls and I want to change it to
Sites_2.xls before I open it.

Thanks

[mudraker]

How are you opening the file?

if via a macro then use this line of code

Name "C:\Test.txt" As "C:\Test01.txt"

[walid66]

yes I am using a macro.

thanks