ExcelBanter - Name of VBAProject ???

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Name of VBAProject ??? (https://www.excelbanter.com/excel-programming/416801-name-vbaproject.html)

Charlotte E.

Name of VBAProject ???

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,

Bob Phillips[_3_]

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,

All times are GMT +1. The time now is 02:10 AM.