PC Review


Reply
Thread Tools Rate Thread

application running in excel 2003 gives missing reference in excel2000

 
 
Prince
Guest
Posts: n/a
 
      13th Feb 2009
Hi All,

I have a strange problem.


when I migrated a running application by compiling it from excel 2000
to excel 2003.

It runs fine. But suppose if I compile it in excel2003 and then put it
back to VSS or storage location and then save it Windows 2000 Desktop
and try compile it again it gives missing reference error.

I fail to understand what happens if i compile the running application
in 2000 and again compile it in 2003 and put it back it gives the
missing reference.

The Files missing as shown in the reference window are:

Missing: Microsoft Word11.0 Object Librarary. (This is what is
missing)
Ref Edit Control

Any suggestions from you friends.

Regards,

Prince
 
Reply With Quote
 
 
 
 
Prince
Guest
Posts: n/a
 
      13th Feb 2009
On Feb 13, 12:39*pm, Prince <prince...@gmail.com> wrote:
> Hi All,
>
> I have a strange problem.
>
> when I migrated a running application by compiling it from excel 2000
> to excel 2003.
>
> It runs fine. But suppose if I compile it in excel2003 and then put it
> back to VSS or storage location and then save it Windows 2000 Desktop
> and try compile it again it gives missing reference error.
>
> I fail to understand what happens if i compile the running application
> in 2000 and again compile it in 2003 and put it back it gives the
> missing reference.
>
> The Files missing as shown in the reference window are:
>
> Missing: Microsoft Word11.0 Object Librarary. (This is what is
> missing)
> Ref Edit Control
>
> Any suggestions from you friends.
>
> Regards,
>
> Prince


The answer to this issue is that the excel 2000 when saved in windows
2003 desktop itself upgrades the above reference from
Microsoft Word9.0 Object Librarary
to
Microsoft Word11.0 Object Librarary

but in the reverse case it is not able to downgrade the reference back
to 9.0.

Hence we need to manually go and select
Microsoft Word9.0 Object Librarary in the reference and then save and
run it then it will compile properly.

Regards,

Prince
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Excel 12.0 Application on Office 2003 BK Microsoft Excel Programming 2 6th May 2010 11:37 PM
Excel 2003 VBProject Missing reference John Howard Microsoft Excel Programming 4 16th Dec 2008 08:01 PM
Running Excel 2000 VBA Application on Excel 2003 ZimFL Microsoft Excel Programming 3 9th Aug 2006 07:55 AM
Running Excel 2000 VBA Application on Excel 2003 Microsoft Excel Worksheet Functions 0 8th Aug 2006 06:04 PM
Missing Reference in Excel 2003 Dirk Franke Microsoft Excel Misc 5 26th Jan 2005 01:24 PM


Features
 

Advertising
 

Newsgroups
 


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