Determine office version that is running on users machine

  • Thread starter Thread starter Dale Fye
  • Start date Start date
D

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.
 
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.
 
Use the latest version.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
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.
 
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.
 
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.
 
Back
Top