equivalent type libraries in earlier versions of office

[Joe Garner]

Hi there,

I want to add a piece of code at the start of my application that looks for
broken references and searches for earlier type libaries: this will allow
the program to work on any computer with office 97 or later installed. The
probelm i'm having is that the developer's dll database doesn't provide this
kind of crossreferencing.

Does anyone know where i could find out the filenames or GUID for the
powerpoint and excel type libraries in 97, 2000 and XP versions of office?

Thanks!

Joe

 

[Paul Overway]

Your best bet is to use late binding whenever possible. Otherwise, you
should develop on a system with the older libraries. Note you cannot change
references in an MDE, so, this is an important issue to resolve.

Late binding example is as follows:

Dim x as Object

Set x = CreateObject("Excel.Application")

You lose IntelliSense when using late binding, but gain the ability to trap
for errors if the object is not available/installed (you'll get error 429).

 

[Joe Garner]

Thanks paul. Maybe the best option is to simply make an separate MDE file on
each version of office...

....sigh

cheers

Joe.

 

[TC]

Yuk! Late binding is the way to go.

TC

Thanks paul. Maybe the best option is to simply make an separate MDE file on
each version of office...

...sigh

cheers

Joe.