Multiple versions of word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joseph Halberstam - 07 Nov 2004 00:45 GMT

Hi,

I need to create a com add-in that will run in all versions of Excel and
Word 2000 and higher.

Anyone have suggestions???

Thanks,

-Yossi

Reply to this Message

Jezebel - 07 Nov 2004 01:28 GMT

1. Develop it using the earliest version of these products that you intend
to support.

2. Use CreateObject and GetObject to instantiate your reference to the
applications (instead of adding a project reference). You might find it
convenient to use a project reference while you're developing, to get the
benefit of intellisense and syntax checking; but remove the reference before
compiling -- then the app will use whatever version the user actually has
installed.

3. Use the Application.Version property to check whether the user has an
acceptable version.

> Hi,
>
[quoted text clipped - 6 lines]
>
> -Yossi

Reply to this Message

Steve Rindsberg - 07 Nov 2004 16:06 GMT

> 3. Use the Application.Version property to check whether the user has an
> acceptable version.

And note that .Version returns a string that doesn't necessarily contain
all-numeric characters. Something like:

If Application.Version > 8 Then

will work most of the time but will error if you run it in Office 97 SR1a I
think it is, which returns "8.0b" for .Version

It seems safe to use:

If Clng(Val(Application.Version)) > 8 Then

Reply to this Message