Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error Trap | Excel Programming | |||
Error Trap | Excel Programming | |||
error trap | Excel Programming |