Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Before I begin let me say that I have already tried the usual pat
answer I find on these groups. It does not work. So please give me something I can use. And I am perfectly aware of the virtues of "late binding" vs. "early". It is in fact why I need to remove these missing references via code (dont ask me to do it manually). Pat answer: Cycle through the References collection for the VBProject and use the IsBroken property to locate the missing reference and then use the Remove method to remove it. Wakeup Call: IT DOES NOT WORK. IsBroken is a method of the object. If you cannot load the object, you cannot use the method. Thus you get "Runtime Error 48" "Error in loading DLL". Even if I trap for the error, I cannot get the Remove method to work. It acts like it is working but the "MISSING:" reference remains. Bringing it Home: Thanks to a bug in the MSOffice 2002 (XP) when users open up an excel document developed in XP and then reopen it in Office 2003, all the version specific references are converted from 10.0 to 11.0. This is great for Windows 2003. However try to do the same in reverse. I mean open up the document saved under 2003 in MSOffice 2002. All the references in the code revert back to 10.0. ALL EXCEPT FOR "Microsoft Word 11.0 Object Library". It remains marked "MISSING:". Worse yet the Word 10.0 Object Lib is not checked breaking our code. Frustrated (a bit), Jamie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string | Excel Worksheet Functions | |||
"Relative" Absolute Cell References in Excel 2007 | Excel Worksheet Functions | |||
Missing data and "invalid references" | Charts and Charting in Excel | |||
"References" Missing in Excel???? | Excel Discussion (Misc queries) | |||
cell references increase by 3 per row "=I1" then "=I4" | Excel Discussion (Misc queries) |