Vladimir Morozov's Library tagged visualbasic → View Popular

Filter:
All
Annotated

02 Mar 07

auto loading vb reference libraries - Excel Help/VBA Help:

www.ozgrid.com/...showthread.php - Preview

f you don't know the GUID then reference it (by ticking it) and then run this to list all the active libraries and their GUIDs - adapted from NateO post on Mr E

VBA:

Sub Grab_References() 
     
    Dim n As Integer 
     
    Sheets.Add 
    ActiveSheet.Name = "GUIDS" 
     
    On Error Resume Next 
    For n = 1 To ActiveWorkbook.VBProject.References.Count 
        Cells(n,1) = ActiveWorkbook.VBProject.References.Item(n).Name 
        Cells(n,2) = ActiveWorkbook.VBProject.References.Item(n).Description 
        Cells(n,3) = ActiveWorkbook.VBProject.References.Item(n).GUID 
        Cells(n,4) = ActiveWorkbook.VBProject.References.Item(n).Major 
        Cells(n,5) = ActiveWorkbook.VBProject.References.Item(n).Minor 
        Cells(n,6) = ActiveWorkbook.VBProject.References.Item(n).fullpath 
    Next n 
     
End Sub