1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
NbreRef = ThisWorkbook.VBProject.References.Count
y = 11
x = 1
Set ThisProj = ActiveWorkbook.VBProject
For Each thisref In ThisProj.References
Cells(x, y) = thisref.Name
x = x + 1
Cells(x, y) = thisref.Description
x = x + 1
Cells(x, y) = thisref.Guid
x = x + 1
Cells(x, y) = thisref.FullPath
'SI PAS PRESENTE
If thisref.IsBroken = True Then
ThisWorkbook.VBProject.References.AddFromFile thisref.FullPath 'ON LA MET
MsgBox "La bibliotheque " & thisref.Name & " a été ajoutée"
Else
MsgBox "Bibliotheque " & thisref.Name & " déja présente"
End If
y = y + 1
x = 1
Next |
Partager