这个相对路径就比较麻烦,主要问题是MSAccess.exe不是你的应用程序,再者,你自己的程序有一个安装路径,Office也有一个安装路径,这两者怎么相对?一般方法就是使用findexecutable这个api函数找到一个mdb文件的可执行文件的路径,再执行它(mdb文件必须存在,你可以使用open for 这样的语句创建一个0字节后缀为mdb文件,然后再使用findexecutable,你也可以带一个空库,或者指向一个已存在的路径固定的mdb文件)
你可以通过读注册表 找出 ACCESS的安装路径 Option ExplicitConst REG_EXPAND_SZ = 2 Const HKEY_CLASSES_ROOT = &H80000000 Const HKEY_CURRENT_USER = &H80000001 Const HKEY_LOCAL_MACHINE = &H80000002 Const HKEY_USERS = &H80000003 Const HKEY_PERFORMANCE_DATA = &H80000004 Const ERROR_SUCCESS = 0&Const RegLocation = "software\UnpreXisten\Online Code Browser\" Const RegKey = HKEY_LOCAL_MACHINE Dim AppVer As String * 8Declare Function RegCloseKey Lib "advapi32.dll" (ByVal Hkey As Long) As LongDeclare Function RegCreateKey Lib "advapi32.dll" Alias "RegCreateKeyA" (ByVal Hkey As Long, ByVal lpSubKey As String, phkResult As Long) As LongDeclare Function RegDeleteKey Lib "advapi32.dll" Alias "RegDeleteKeyA" (ByVal Hkey As Long, ByVal lpSubKey As String) As LongDeclare Function RegDeleteValue Lib "advapi32.dll" Alias "RegDeleteValueA" (ByVal Hkey As Long, ByVal lpValueName As String) As LongDeclare Function RegOpenKey Lib "advapi32.dll" Alias "RegOpenKeyA" (ByVal Hkey As Long, ByVal lpSubKey As String, phkResult As Long) As LongDeclare Function RegQueryValueEx Lib "advapi32.dll" Alias "RegQueryValueExA" (ByVal Hkey As Long, ByVal lpValueName As String, ByVal lpReserved As Long, lpType As Long, lpData As Any, lpcbData As Long) As LongDeclare Function RegSetValueEx Lib "advapi32.dll" Alias "RegSetValueExA" (ByVal Hkey As Long, ByVal lpValueName As String, ByVal Reserved As Long, ByVal dwType As Long, lpData As Any, ByVal cbData As Long) As Long Const REG_SZ = 1 Const REG_DWORD = 4Public Enum OfficeVer Office_97 Office_2000 Office_xp Office_2003 End Enum '<CSCM> '-------------------------------------------------------------------------------- ' 工 程 名: 工程1 ' 函 数 名: GetString ' 变 量 : OfKind (OfficeVer) ' 输 入:无 ' 输 出:OFFICE 的路径 '我的机器没有OFFICE xp 根据97 200 2003的关系 '可以看出键值为"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\10.0\Common\InstallRoot" ' 日 期 : 2005-7-5 ' 作 者 : 许仙'-------------------------------------------------------------------------------- '</CSCM> Public Function GetOfficePath(OfKind As OfficeVer) As String Dim lValueType Dim keyhand As Long, r Dim datatype As Long Dim lResult As Long Dim strBuf As String Dim lDataBufSize As Long Dim intZeroPos As Integer, StrKeyName$ Select Case OfKind Case 0 r = RegOpenKey(HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Office\8.0\Common\InstallRoot", keyhand) StrKeyName = "OfficeBin" Case 1 r = RegOpenKey(HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Office\9.0\Common\InstallRoot", keyhand) StrKeyName = "Path" Case 2 r = RegOpenKey(HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Office\10.0\Common\InstallRoot", keyhand) StrKeyName = "Path" Case 3 r = RegOpenKey(HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Office\11.0\Common\InstallRoot", keyhand) StrKeyName = "Path" End Select lResult = RegQueryValueEx(keyhand, StrKeyName, 0&, lValueType, ByVal 0&, lDataBufSize) If lValueType = REG_SZ Then strBuf = String(lDataBufSize, " ") lResult = RegQueryValueEx(keyhand, StrKeyName, 0&, 0&, ByVal strBuf, lDataBufSize) If lResult = ERROR_SUCCESS Then intZeroPos = InStr(strBuf, Chr$(0)) If intZeroPos > 0 Then GetOfficePath = Left$(strBuf, intZeroPos - 1) Else GetOfficePath = strBuf End If End If End IfEnd Function
Option ExplicitConst REG_EXPAND_SZ = 2
Const HKEY_CLASSES_ROOT = &H80000000
Const HKEY_CURRENT_USER = &H80000001
Const HKEY_LOCAL_MACHINE = &H80000002
Const HKEY_USERS = &H80000003
Const HKEY_PERFORMANCE_DATA = &H80000004
Const ERROR_SUCCESS = 0&Const RegLocation = "software\UnpreXisten\Online Code Browser\"
Const RegKey = HKEY_LOCAL_MACHINE
Dim AppVer As String * 8Declare Function RegCloseKey Lib "advapi32.dll" (ByVal Hkey As Long) As LongDeclare Function RegCreateKey Lib "advapi32.dll" Alias "RegCreateKeyA" (ByVal Hkey As Long, ByVal lpSubKey As String, phkResult As Long) As LongDeclare Function RegDeleteKey Lib "advapi32.dll" Alias "RegDeleteKeyA" (ByVal Hkey As Long, ByVal lpSubKey As String) As LongDeclare Function RegDeleteValue Lib "advapi32.dll" Alias "RegDeleteValueA" (ByVal Hkey As Long, ByVal lpValueName As String) As LongDeclare Function RegOpenKey Lib "advapi32.dll" Alias "RegOpenKeyA" (ByVal Hkey As Long, ByVal lpSubKey As String, phkResult As Long) As LongDeclare Function RegQueryValueEx Lib "advapi32.dll" Alias "RegQueryValueExA" (ByVal Hkey As Long, ByVal lpValueName As String, ByVal lpReserved As Long, lpType As Long, lpData As Any, lpcbData As Long) As LongDeclare Function RegSetValueEx Lib "advapi32.dll" Alias "RegSetValueExA" (ByVal Hkey As Long, ByVal lpValueName As String, ByVal Reserved As Long, ByVal dwType As Long, lpData As Any, ByVal cbData As Long) As Long
Const REG_SZ = 1
Const REG_DWORD = 4Public Enum OfficeVer
Office_97
Office_2000
Office_xp
Office_2003
End Enum
'<CSCM>
'--------------------------------------------------------------------------------
' 工 程 名: 工程1
' 函 数 名: GetString
' 变 量 : OfKind (OfficeVer)
' 输 入:无
' 输 出:OFFICE 的路径
'我的机器没有OFFICE xp 根据97 200 2003的关系
'可以看出键值为"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\10.0\Common\InstallRoot"
' 日 期 : 2005-7-5
' 作 者 : 许仙'--------------------------------------------------------------------------------
'</CSCM>
Public Function GetOfficePath(OfKind As OfficeVer) As String Dim lValueType
Dim keyhand As Long, r
Dim datatype As Long
Dim lResult As Long
Dim strBuf As String
Dim lDataBufSize As Long
Dim intZeroPos As Integer, StrKeyName$ Select Case OfKind Case 0
r = RegOpenKey(HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Office\8.0\Common\InstallRoot", keyhand)
StrKeyName = "OfficeBin" Case 1
r = RegOpenKey(HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Office\9.0\Common\InstallRoot", keyhand)
StrKeyName = "Path" Case 2
r = RegOpenKey(HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Office\10.0\Common\InstallRoot", keyhand)
StrKeyName = "Path" Case 3
r = RegOpenKey(HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Office\11.0\Common\InstallRoot", keyhand)
StrKeyName = "Path" End Select lResult = RegQueryValueEx(keyhand, StrKeyName, 0&, lValueType, ByVal 0&, lDataBufSize) If lValueType = REG_SZ Then strBuf = String(lDataBufSize, " ")
lResult = RegQueryValueEx(keyhand, StrKeyName, 0&, 0&, ByVal strBuf, lDataBufSize) If lResult = ERROR_SUCCESS Then intZeroPos = InStr(strBuf, Chr$(0)) If intZeroPos > 0 Then GetOfficePath = Left$(strBuf, intZeroPos - 1) Else GetOfficePath = strBuf End If End If End IfEnd Function