Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
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
References.Remove References(1) DOES NOT WORK for "MISSING:" Refs Jamie Carper[_2_] Excel Programming 0 May 27th 04 04:22 PM
MIssing References RJ Excel Programming 3 April 5th 04 04:02 AM
Missing References Steve Andrews Excel Programming 0 January 20th 04 03:26 PM
Bad or Missing References Bill B[_3_] Excel Programming 0 January 8th 04 01:29 PM
Missing References between Excel Versions Merkling, Steven Excel Programming 0 November 25th 03 02:40 PM


All times are GMT +1. The time now is 01:42 PM.

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

About Us

"It's about Microsoft Excel"