file version number

[sstreet]

Is there any way to check the version number of a file from access?

I am currently deploying Office XP Service Pack 2 across the network and need to check whether the updates have worked or not. The easiest way to do this is to check the version number of the excel.exe file. Doing this individually would take weeks.

Please Help!

Thanks

 

[Fizzio]

Yep.

http://www.mvps.org/access/api/api0065.htm

 

[sstreet]

That's great, thanks!

Do I put this code in a module?
How do get the values, call the function?

 

[Fizzio]

Yes, put the code in a module and call the function from wherever you want it displayed - eg in a textbox

set the controlsource of the textbox to

=fGetProductVersion("excel.exe")

 

[sstreet]

That work perfectly, but how would I use the same function to get the version number of a file on another PC on the network e.g. wks01?

 

[Fizzio]

I have not tried that yet but I suppose (in theory!) that you could enter the path to the other computer in another textbox (or more hi tech browse for a network computer using a browse API/common dialog ) and set the controlsource to

=fGetProductVersion(Forms!NameofForm!NameofPathTextBox & "excel.exe")

don't know if this will work mind you

 

[sstreet]

I have sorted that:
=fGetProductVersion("\\PCNAME\c$\Program Files\Microsoft Office\Office10\excel.exe")

 

[Fizzio]

Glad it worked. The advantage of using a textbox and referring to the form control will allow you to check many computers without hardcoding the UNC path every time.