Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
version of excel and word installed on target?
- Thread starter hinchdog
- Start date
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
You can do this for Excel.Application, etc.
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
You can do this for Excel.Application, etc.
- Status
