Rename Excel file name

[Jack40]

Hi,

Can any one help to rename an excel file while it is open using macro.

Regards

Jack.R

[mohan.r1980]

by which name you want to rename,
provide full detail what you want

[Jack40]

Hi Mohan,

I want to rename the another file which is open to put vlookup with this two files. but i did it.. any way thanks for your help..


Regards

jack