Problem updating references earlier version

Hello,
I have a VB6/MS Office Excel/Word VBA app configured in Win XP Office 2003.
I am trying to make it compatible with earlier versions of Office-Office 97
on a Win 98 platform at present-and after researching have decided to try
late binding. According to MS documentation, the application should update
its references when opened in the earlier Office 97 version. It has done this
for 6 of 8 references: except for the MS Word reference-it is still looking
for Word 11.0 in the same location as was on the original, newer platform.
Then it is also looking for the MS VBA Extensibility 5.3 file in the location
of the original, newer platform as well.

Does anyone have an idea how I can get my app to point to the correct 2
references per above? Also should the Extensibility reference be to the newer
5.3 version (vbe6ext.olb) which per KB article 269116 is a replacement for
the earlier older type library (which I am guessing is vbeext1.olb as that is
what I find on my Office 97 platform);and if so 1) should I add that to my
installer application. 2) how do I get it to point to the correct location?
Will I need to use code to locate and set the reference to the file?
Thanks, blessings
Van

Jonathan
Fri Jan 07 16:24:44 CST 2005

Hi VanS

The conventional way of handing support of multiple versions of Office is to
use late binding.

1. Remove all references to Office libraries from your project
2. Declare all office based object variables as being of type Object
3. Create references to the main application objects using GetObject or
CreateObject, and access the object models from that point.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup


"VanS" <VanS@discussions.microsoft.com> wrote in message
news:84FDBC5B-456B-4F44-BE9F-44BA6BDC74D2@microsoft.com...
> Hello,
> I have a VB6/MS Office Excel/Word VBA app configured in Win XP Office
> 2003.
> I am trying to make it compatible with earlier versions of Office-Office
> 97
> on a Win 98 platform at present-and after researching have decided to try
> late binding. According to MS documentation, the application should update
> its references when opened in the earlier Office 97 version. It has done
> this
> for 6 of 8 references: except for the MS Word reference-it is still
> looking
> for Word 11.0 in the same location as was on the original, newer platform.
> Then it is also looking for the MS VBA Extensibility 5.3 file in the
> location
> of the original, newer platform as well.
>
> Does anyone have an idea how I can get my app to point to the correct 2
> references per above? Also should the Extensibility reference be to the
> newer
> 5.3 version (vbe6ext.olb) which per KB article 269116 is a replacement for
> the earlier older type library (which I am guessing is vbeext1.olb as that
> is
> what I find on my Office 97 platform);and if so 1) should I add that to my
> installer application. 2) how do I get it to point to the correct
> location?
> Will I need to use code to locate and set the reference to the file?
> Thanks, blessings
> Van
>
>

Jonathan
Tue Jan 18 09:36:15 CST 2005

If your application is running in Excel, then you wouldn't want to remove
the Excel VBA or Office libraries from Tools References. It is just the Word
library that should be removed.

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup


"VanS" <VanS@discussions.microsoft.com> wrote in message
news:8C4F2F1E-8EA7-4156-90AA-B3FBCF42A78C@microsoft.com...
> Jonathan,
> I tried to remove the Office references as you suggested which I was able
> to
> do for those from Office specifically, except for the Excel 11.0
> Library-it
> gave an error message that the file was in use. My application runs in
> Excel.
> So do you have any suggestions on how I can get around this to remove this
> reference?
> Thanks
> Van
>
> "Jonathan West" wrote:
>
>> Hi VanS
>>
>> The conventional way of handing support of multiple versions of Office is
>> to
>> use late binding.
>>
>> 1. Remove all references to Office libraries from your project
>> 2. Declare all office based object variables as being of type Object
>> 3. Create references to the main application objects using GetObject or
>> CreateObject, and access the object models from that point.
>>
>>
>> --
>> Regards
>> Jonathan West - Word MVP
>> www.intelligentdocuments.co.uk
>> Please reply to the newsgroup
>>
>>
>> "VanS" <VanS@discussions.microsoft.com> wrote in message
>> news:84FDBC5B-456B-4F44-BE9F-44BA6BDC74D2@microsoft.com...
>> > Hello,
>> > I have a VB6/MS Office Excel/Word VBA app configured in Win XP Office
>> > 2003.
>> > I am trying to make it compatible with earlier versions of
>> > Office-Office
>> > 97
>> > on a Win 98 platform at present-and after researching have decided to
>> > try
>> > late binding. According to MS documentation, the application should
>> > update
>> > its references when opened in the earlier Office 97 version. It has
>> > done
>> > this
>> > for 6 of 8 references: except for the MS Word reference-it is still
>> > looking
>> > for Word 11.0 in the same location as was on the original, newer
>> > platform.
>> > Then it is also looking for the MS VBA Extensibility 5.3 file in the
>> > location
>> > of the original, newer platform as well.
>> >
>> > Does anyone have an idea how I can get my app to point to the correct
>> > 2
>> > references per above? Also should the Extensibility reference be to the
>> > newer
>> > 5.3 version (vbe6ext.olb) which per KB article 269116 is a replacement
>> > for
>> > the earlier older type library (which I am guessing is vbeext1.olb as
>> > that
>> > is
>> > what I find on my Office 97 platform);and if so 1) should I add that to
>> > my
>> > installer application. 2) how do I get it to point to the correct
>> > location?
>> > Will I need to use code to locate and set the reference to the file?
>> > Thanks, blessings
>> > Van
>> >
>> >
>>
>>