LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default References.Remove References(1) DOES NOT WORK for "MISSING:" Refs

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string Raja Mahendiran S Excel Worksheet Functions 6 May 12th 10 09:10 PM
"Relative" Absolute Cell References in Excel 2007 [email protected] Excel Worksheet Functions 4 December 29th 07 04:48 PM
Missing data and "invalid references" Jordlaw Charts and Charting in Excel 0 September 11th 07 02:20 PM
"References" Missing in Excel???? Bob Barnes Excel Discussion (Misc queries) 4 March 1st 07 09:06 PM
cell references increase by 3 per row "=I1" then "=I4" jwk515 Excel Discussion (Misc queries) 3 May 9th 06 02:00 AM


All times are GMT +1. The time now is 03:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"