Show the excel filename
 

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

Show the excel filename
 

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

Show the excel filename
 

Try this

MsgBox ActiveWorkbook.FullName

--
Regards Ron de Bruin
http://www.rondebruin.nl


"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