I've been using this technique to open an excel file, with great sucess. An instance of excel is opened, and the specified file is loaded. When the subroutine completes, the excel application remains open.
Sub OpenExcelApp(strPathAndFile As String)
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Sheet")
xlApp.Application.Visible = True
Now, I need to open an access application, and would like to use the same technique. But it doesn't work the same way! When the subroutine completes, the newly opened access application shuts down.
Sub OpenAccessApp(strPathAndFile As String)
Dim oAccApp As Object
Set oAccApp = CreateObject("Access.Application")
oAccApp.Application.Visible = True
Does anyone know how I can launch an access app, from access?