Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 220
Default Cannot use .IsBroken property of a Reference object - error 48

I am having the same trouble as what is in the following post:

http://groups-beta.google.com/group/...42e1acb7a21d59


I cannot use the .IsBroken property because an error pops up "Error in
loading DLL". What i intended to do was remove all broken references
from a project and restore them using addbyfilepath.

For example, in my case, A reference used to exist and it has since been
unregistered and the file replaced with an updated file (which has a new
GUID). The reference is "broken", but in such a way as to be immune
from programmatic deletion. If i try to remove the broken component, I
get the same error that I do using the .IsBroken property.

Is there anyway around this? Any help would be most appreciated.

' This code fails.
Public Sub asldhgh()
Dim ref As VBIDE.Reference, proj As VBProject

For Each proj In Application.VBE.VBProjects
For Each ref In proj.References
If ref.IsBroken Then Debug.Print ref.Name
Next
Next
End Sub
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error accessing external object property XVALUES sergio Excel Discussion (Misc queries) 2 February 7th 07 04:47 PM
object reference does not support this property or method [email protected] Excel Discussion (Misc queries) 2 June 14th 06 07:23 PM
Object doesn't support this property or method (Error 438) Kiran Excel Discussion (Misc queries) 1 July 12th 05 08:42 PM
Error accessing external object property vbe NilovSerge Excel Programming 1 June 21st 04 12:48 PM
IsBroken property DennisE Excel Programming 2 January 24th 04 06:21 PM


All times are GMT +1. The time now is 01:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"