Show the excel filename

W

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
 
N

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:
 
Top