excel version and servicepack

[sanjay wankhede]

Hi,
Is there any API( may be windows) to directly ready the
Excel version,Build and servicepack information?
I do not see any propery of Excel.Application in VBA code
to figure out the service pack though I could get the
version and build.
Thanks
-sanjay

 

[Rob Bovey]

Is there any API( may be windows) to directly ready the
Excel version,Build and servicepack information?
I do not see any propery of Excel.Application in VBA code
to figure out the service pack though I could get the
version and build.

Hi Sanjay,

The build number uniquely identifies the service pack in all but rare
special cases. The problem is determining which build numbers correspond to
which service packs. I used to keep a list of these but it's been so long
since I needed to use them that I stopped collecting the information.

The easiest thing to do might be to just remove Office from your
computer, then reinstall the original version followed by each service pack,
checking the build numbers as you go along to see what they are. In the vast
majority of cases, the build number that you see for a given service pack on
your machine will be exactly the same build number for that service pack on
any other machine.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[Chip Pearson]

You can get the Version and Build numbers from the Application
object.

Debug.Print Application.Version
Debug.Print Application.Build



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com