Returns all the file names of the user macros available in the VBA environment.

Syntax:

 
GetUserMacrosFilenames(FilenameArray As Variant)
Parameters: FilenameArray Dynamic array of variants not yet resized. The file names will be stored in this array.
Example: 
Dim Tool As VBATool
Dim FilenameArray() As Variant
Dim i As Integer

Set Tool = Application.Tools.VBATool

Call Tool.GetUserMacrosFilenames(FilenameArray)

For i = LBound(FilenameArray) To UBound(FilenameArray)
    MsgBox FilenameArray(i)
Next i

See also:

Class VBATool

Last Updated: 04/27/05