Gustav Brock
gustav at cactus.dk
Fri Jun 25 09:04:10 CDT 2004
Hi Susan I have not an Access 2000 installation right on hand. Similar code works here with the minor difference that Access is preceding "everywhere": Dim ref As Access.Reference .. Access.Application.References /gustav > 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