This is something I have used to connect to ACAD. There is an option to connect to an existing session. It uses a global to set AutoCAD.app to that global...
Function OpenAcadApp(Optional bAcVisiblity As Boolean = True, _
Optional bConnectToExisting As Boolean = False) 'As AcadApplication
'------------------------------------------------------------------------------
'OpenAcadApp: Establish a connection to Autocad or create one if none exists
'Arguments: Visibility: default True
' Connect to running session - default FALSE
'Issues: "Asks for FONTALT"
'------------------------------------------------------------------------------
Dim iCnt As Integer: iCnt = 0
'Dim objAcadApp As AcadApplication
If bConnectToExisting = True Then
On Error Resume Next
Set objAcadApp = GetObject(, "AutoCAD.Application"
Select Case Err.Number
Case 429 'Autocad not started already
Err.Clear
GoTo Restart
Case 0 'AutoCad already running
Exit Function
End Select
End If
Restart:
Set objAcadApp = CreateObject("AutoCAD.Application"

If Err.Number = 91 Then
Err.Clear
If iCnt = 3 Then
Exit Function
Else
GoTo Restart
iCnt = iCnt + 1
End If
Else
Err.Clear
End If
'--------------------------------------------------------------------------
'Set the Visibility option
'--------------------------------------------------------------------------
objAcadApp.Visible = bAcVisiblity
'Set OpenAcadApp = objAcadApp
End Function