Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Access
Hi
I need to determine if an access application is already open from excel VBA. I have no problems opening the file if it is already closed but when i try to get the cureent access aplication i get nothing. Any help would be appreciated. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Access
Try the following:
Function isAccessOpen() As Boolean On Error Resume Next Dim oAccessApp As Object Set oAccessApp = GetObject(, "Access.Application") If Err.Number = 429 Then isAccessOpen = False ElseIf Err.Number < 0 Then MsgBox "Untrapped error: " & Err.Number & vbCrLf & Err.Description isAccessOpen = False Else isAccessOpen = True End If Set oAccessApp = Nothing End Function /i. "Stuart" wrote in message ... Hi I need to determine if an access application is already open from excel VBA. I have no problems opening the file if it is already closed but when i try to get the cureent access aplication i get nothing. Any help would be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open access from excel ? | Excel Discussion (Misc queries) | |||
Open Access Database with VBA | Excel Discussion (Misc queries) | |||
Excel cannot open Access MDB | Excel Discussion (Misc queries) | |||
Open Ms Access File | Excel Programming | |||
Open Excel from access | Excel Programming |