Removing Unregistered Library

[DNF Karran]

Hi all,

I'm currently going round in circles with this one:

I have a workbook that has been created in xl 2000 and sends e-mail
from outlook. However, when the file is opened and saved in Excel 200
the references to the Outlook v9.0 library change to Outlook v11.0
This would be fine except the file has to run in office 2000, xp an
2003.

Help!!!

When the file is re-opened in excel 2000 the outlook library doesn'
change back from xp to 2000. I have been trying various forms of VBA t
remove the reference library link but with no success. I keep gettin
error "Object Library Not Registered". If I can remove this the idea i
to change it back to outlook 2000 when opened in 2000 and let xp/200
change it to whatever they want.

anybody have any potential solutions/ new approaches. The only way
can see at the moment is to make the library load/unload when the fil
is opened and closed to aviod this problem in the first place. Othe
possibles are having the 2000 object library kept with the file an
linking to that instead of prog files/ms office.

The latest code I have been using is:

For i = 1 To ThisWorkbook.VBProject.References.Count
If ThisWorkbook.VBProject.References(i).IsBroken = True Then
ThisWorkbook.VBProject.References.Remov
ThisWorkbook.VBProject.References(i)
End If
Next i

I have also tried various method/syntax changes but to no avail.

Dunca

 

[Dave Peterson]

If you're working with multiple versions of excel/outlook, you may want to use
the references when you're developing (nice for intellisense).

But before you release to your users, you could change your code to use late
binding.

You may want to take a look at Dick Kusleika's site for more info:
http://dicks-clicks.com/excel/olBinding.htm