I'm new to vbscripting and am a bit lost... I am trying to create a script that checks for the installed version of MS Office. I understand that the SysCmd method will give the major version information for MS Access..and therefore the version of MS Office.

My question is... Does this method only work from WITHIN MS Access? I get "...illegal function call..." errors when calling it from a .vbs.

Thanks,
Cj.

SysCmd is access vba not vbscript. Take a look here www.tek-tips.com/viewthread.cfm?qid=1088751 for tips on how to get the access version. But are you sure that you can assume the Access came with MSOffice? I have Office XP (2002) without Access, and I also have Access 97 so if you used that method on my setup you would be assuming I have Office 97!

Here's a way to get the Word version
http://www.microsoft.com/technet/scr...5/hey0110.mspx
you can probably do the same for Excel using it's Application object.

hth
Phil

Ah - Same idea, but w/Word instead of Access...and it works! :D You're right about the likelihood of someone having a different version of Access than Office (definitely less accurate than Word/Office)...

Thanks Phil!

Cj.

BTW: In case anyone else is wondering...here's the 4 simple lines of code... Also - You can make it remote by giving the name of the machine when you create the app object.

IE:
Set objWord = CreateObject("Word.Application", "Remote_Machine_Name")

4 simple lines:
Set objWord = CreateObject("Word.Application")
Wscript.Echo "Version: " & objWord.Version
Wscript.Echo "Build: " & objWord.Build
objWord.Quit