| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBAProject | Excel Programming | |||
| VBAProject | Excel Worksheet Functions | |||
| UNSAVED: VBAProject | Excel Programming | |||
| VBAProject scope | Excel Programming | |||
| How to get rid of a VBAProject? | Excel Programming | |||
Hybrid Mode
