LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 337
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Testing under Office 07 and getting #DIV/0! and #VALUE! TKM Excel Programming 1 October 16th 08 06:18 PM
Multiple Office Versions AG[_9_] Excel Programming 12 July 21st 08 01:54 PM
Is solver different between Office versions? Jan Hime[_2_] Excel Worksheet Functions 1 January 15th 08 08:11 PM
Using Macros across different office versions PMC1 Excel Programming 2 May 15th 07 02:02 PM
Anyone Beta Testing Office 2007 Jessica Excel Discussion (Misc queries) 2 August 30th 06 03:13 PM


All times are GMT +1. The time now is 06:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"