 - Public Function GetVBAProjects()
-
- Dim i As Long, projects() As String Dim objIDE As Object
-
- Set objIDE = Application.vbe
-
- ReDim projects(0 To objIDE.VBProjects.Count - 1, 1)
- On Error Resume Next
- For i = 0 To objIDE.VBProjects.Count - 1
- projects(i, 0) = objIDE.VBProjects(i + 1).Name
- projects(i, 1) = objIDE.VBProjects(i + 1).FileName
- Next
-
- GetVBAProjects = projects
-
- End Function
|