Assign an excel open workbook name to a avariable

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.

VB Code:

' After the workbook is opened, it will be the active workbook.
 
' Name property returns the name.
n = ActiveWorkbook.Name
 
' FullName returns the full path where the workbook is saved.
n = ActiveWorkbook.FullName
 
' Workbooks(n) returns the name of a specific open work book.
' In this case n = 2 so it returns the name of the 2nd open workbook.
n = Workbooks(2).Name

:)