Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for different versions of Office
I have the following macro that opens an access database. I have some people
that are using Access 2000. Is there any way I can test to see what version they are using and open that Access version? Private Sub CommandButton5_Click() 'Add new substrate Dim X As String X = Shell("C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE \\SERVER3\database\SUBSTRATES.MDB", 1) oldjay End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for different versions of Office
Following appears to work satisfactorily with Access 2002 and Access 2007.
You will need to test with other versions. Sub TestAccessVersion() '9 = Access 2000 '10 = Access 2002/XP '11 = Access 2003 '12 = Access 2007 Dim objAccess As Object Set objAccess = CreateObject("Access.Application") MsgBox objAccess.Version objAccess.Quit Set objAccess = Nothing End Sub -- Regards, OssieMac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Testing under Office 07 and getting #DIV/0! and #VALUE! | Excel Programming | |||
Multiple Office Versions | Excel Programming | |||
Is solver different between Office versions? | Excel Worksheet Functions | |||
Using Macros across different office versions | Excel Programming | |||
Anyone Beta Testing Office 2007 | Excel Discussion (Misc queries) |