Trap error in: ThisWorkbook.VBProject.References.Item(i).FullPath
2003
I am getting an runtime-error with
ThisWorkbook.VBProject.References.Item(i).FullPath
the error message claims not registered. That said, my routine obtains
the following fine:
..Item(i).Name (OK)
..Item(i).Description (OK)
..Item(i).FullPath (fails)
First, I am failing in my attempt to trap the error via: (Please help
on this also)
[ThisWorkbook.VBProject.References]
If IsError(.Item(i).FullPath) Then
Cells(i + 1, 3).Value = "Not in Registery Properly!!"
Else
Cells(i + 1, 3).Value = .Item(i).FullPath
End If
Second, using ToolsReferences, I have "Browsed" to
C:\WINDOWS\System32\scrrun.dll clicked OK to no avail.
How can I force a clean recognition in the Registry so that I do not
get the error in the first place?
TIA EagleOne
|