There's probably many ways to check this, but I would do it looking for certain files on C:\Program Files\Microsoft Office. Excel8.olb is Excel version 8, Excel7.olb is Excel version 7. msword8.olb is Word version 8, MsWord7.Olb is Word version 7, etc.
Another, probably more accurate way to do this, would be to instantiate whichever application you're wondering about. Do this using the following code:
Dim AppWord as Application
Set AppWord = GetObject(, "Word.Application"
Now you'd have the version of Word Available to you by referencing the property AppWord.Version
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.