Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing References
For some time now I'm seeing a strange behavior when
compiling and saving Add-In's on my machine (XP Developer). While the Add-In performs without problems on my machine, they will not run on other machines (XP, Office 2000), debugging the Add-in on the new machine will show that the cause of the problem is always a missing reference for Word 10 (The Add-In calls Word as part of a procedure). If I reselect the Word 9 or 10 Reference on the other machine and recompile/save the Add-In will run on all machines (including mine) without problem. Editing the code and saving the Add-In on my machine will recreate the problem. The missing reference is always an Office App other references are not effected. I can create the same problem in MS Word (Missing an Excel reference in that case). I have re-installed Office XP multiple times and that doesn't seem to cure this problem, I have also tried this with and without the various service packs. I guessing that something in my registry is messed up - anybody have any idea how to fix this (without a complete rebuild of my computer)? Any help is appreciated. Felix |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing References
Using late binding is the usual way to solve problems such as these:
http://support.microsoft.com/default...b;EN-US;244167 INFO: Writing Automation Clients for Multiple Office Versions http://support.microsoft.com/default...b;en-us;245115 INFO: Using Early Binding and Late Binding in Automation http://support.microsoft.com/default...b;en-us;247579 INFO: Use DISPID Binding to Automate Office Applications Whenever Possible -- Regards, Tom Ogilvy "Felix" wrote in message ... For some time now I'm seeing a strange behavior when compiling and saving Add-In's on my machine (XP Developer). While the Add-In performs without problems on my machine, they will not run on other machines (XP, Office 2000), debugging the Add-in on the new machine will show that the cause of the problem is always a missing reference for Word 10 (The Add-In calls Word as part of a procedure). If I reselect the Word 9 or 10 Reference on the other machine and recompile/save the Add-In will run on all machines (including mine) without problem. Editing the code and saving the Add-In on my machine will recreate the problem. The missing reference is always an Office App other references are not effected. I can create the same problem in MS Word (Missing an Excel reference in that case). I have re-installed Office XP multiple times and that doesn't seem to cure this problem, I have also tried this with and without the various service packs. I guessing that something in my registry is messed up - anybody have any idea how to fix this (without a complete rebuild of my computer)? Any help is appreciated. Felix |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
References.Remove References(1) DOES NOT WORK for "MISSING:" Refs | Excel Programming | |||
MIssing References | Excel Programming | |||
Missing References | Excel Programming | |||
Bad or Missing References | Excel Programming | |||
Missing References between Excel Versions | Excel Programming |