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