Hi all,

In a macro in Excel , I open a paticular excel file , for example Tg.xls. Now It's open in a current window.
How can I assign the name of the file to an avariable, for example n ?
(So n should equal to a text "tg.xls" after that.)

Thank you very much for your help.