Senti prova con questa funzione:
codice:
'**************************** shell execute
Declare Function GetActiveWindow Lib "user32" () As Long
Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Public Sub RunFile(ByVal File$, FilePath$, RunStyle)
' SW_HIDE = 0
' SW_SHOWNORMAL = 1
' SW_NORMAL = 1
' SW_SHOWMINIMIZED = 2
' SW_SHOWMAXIMIZED = 3
' SW_MAXIMIZE = 3
' SW_SHOWNOACTIVATE = 4
' SW_SHOW = 5
' SW_MINIMIZE = 6
' SW_SHOWMINNOACTIVE = 7
' SW_SHOWNA = 8
' SW_RESTORE = 9
Const MB_ICONSTOP = 16
Dim temp As String
Dim x
temp = GetActiveWindow()
x = ShellExecute(temp, "Open", File$, "", FilePath$, RunStyle)
End Sub
''Gestione database
Call RunFile("file.mdb", "c:\programmi\", 1)