Susan Harkins
ssharkins at bellsouth.net
Thu Jun 24 13:52:58 CDT 2004
An editor's having trouble with the Remove method in 2K and XP. I was able
to re-create it by running an Access 2003 db with a reference to Excel 2003
on a system with Access 2000 and no Excel. The error says the object doesn't
suppor the method -- and points to the Remove method, but it's there in
Intellisense.
It's only 2000 and 2k -- any ideas?
Susan H.
Sub RemoveBrokenReferences()
'Find and remove broken references
Dim ref As Reference
For Each ref In Application.References
If ref.IsBroken = True Then
Application.References.Remove ref
End If
Next
End Sub