Show the excel filename

[WeWa]

Hi
I want to use macro to show the active worksheet's filename & the path
(e.g c:\excel\test.xls). How to do it? thx
swah

 

[Norman Jones]

Hi WeWa,

With your example, c:\excel\test.xls,

ActiveWorkbook.Name will return the workbook name; test.xls
ActiveWorkbook.Fullname will return the name and path; c:\excel\test.xls:

 

[Ron de Bruin]

Try this

MsgBox ActiveWorkbook.FullName