Get VB project name : VBE « Application « VBA / Excel / Access / Word






Get VB project name

 
Option Explicit

Private VBE As VBIDE.VBE

Public Sub FindProject()
  
  Dim project As VBIDE.VBProject
  Set project = Workbooks("Book1.xls").VBProject
  MsgBox project.Name

End Sub

 








Related examples in the same category

1.Show selected VB component's name
2.Find the code pane
3.Find the selected component in VBIDE
4.Find code object
5.Get active project name
6.Find user form
7.Find worksheet code module
8.Clear Immediate window through VBE
9.Displaying each active VBA component in a worksheet