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:

---
Regards,
Norman



"WeWa" wrote in message
...
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