Determine office version that is running on users machine

[Dale Fye]

I'm in a situation where I have multiple users of a database application that
are using different versions (2003, 2007) of the same application.

I've got a "front end updater" that I'm trying to give the additional
functionality of downloading the correct version of the database. This is
easy if they already have a copy of the database on their computer (I just
look at the file extension), but if they don't already have a copy, or if
they have upgraded since they last used the application, I need a quick and
easy way to determine what version of Office they have installed.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[OssieMac]

Hi Dale,

As this post is in the Excel programming area, I am assuming that you want
to do this in Excel VBA. Following is copied straight out of Excel Help.

MsgBox "Welcome to Microsoft Excel version " & _
Application.Version & " running on " & _
Application.OperatingSystem & "!"

Works in both Excel 2007 and Excel 2002. xl2007 is version 12; 2003 is
version 11 and 2003 is version 11.

 

[Douglas J. Steele]

What do you want to do if they have more than one version installed?

 

[Dale Fye]

Use the latest version.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Dale Fye]

Actually, I posted this message to the Access newsgroups, including
microsoft.public.access.modulesdaovba


--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Douglas J. Steele]

You can check the registry under HKLM\SOFTWARE\Microsoft\Office\n.0 (where n
is 8 for 97, 9 for 2000, 10 for 2002, 11 for 2003 and 12 for 2007) to see
whether there's an Access section.

 

[Dale Fye]

Exactly what I needed.

On the 2003 machine, it returned "11.0" on the 2007 machines, it returns
"12.0"

Since none of the machines have both, it worked great.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.