View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Name of VBAProject ???

MsgBox Application.VBE.ActiveVBProject.Name


--
__________________________________
HTH

Bob

"Charlotte E." wrote in message
...
All VBAProject gets the name "VBAProject" by default.

But sometimes it is nice to be able to rename it - which luckily is easy
done :-)

But, is there anyway to determine the name of the VBA project, which the
current/running macro/sub is placed in?


TIA,