View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dennis Dennis is offline
external usenet poster
 
Posts: 59
Default 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