Thread: Show the excel filename
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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




Reply With QuoteReply With Quote