View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nacho Nachev Nacho Nachev is offline
external usenet poster
 
Posts: 26
Default Remove missing reference programmatically

Hello,

I am accessing Excel object from a C# plugin. Sometimes in my target
documents there are missing Compoment references, which I should remove.

Sorry, I sent it incomplete mistakenly. Here's the whole message.
---

I use the following fragment of code to do this:


for (int j = 1; j <= wbk.VBProject.References.Count; j++)
{
VBIDE.Reference myref = wbk.VBProject.References.Item(j);

if (myref.IsBroken == true)
{
wbk.VBProject.References.Remove(myref);
}
}

The problem is that I get the following exception: for (int j = 1; j <=
wbk.VBProject.References.Count; j++)
{
VBIDE.Reference myref = wbk.VBProject.References.Item(j);

if (myref.IsBroken == true)
{
wbk.VBProject.References.Remove(myref);
}
}

The problem is that I get the following exception: "Object library not
registered". But the reference is still there and I cannot add fresh
reference to the project "Name conflicts with existing module, project, or
object library".

Do you have any suggestion how I get out of this mess and remove the missing
reference successfully?

Thank you for your time,
Nacho