The second method is used when you want to open a particular database or run
a particular query within a database, etc.
HTH,
gary brown

"Gary Brown" wrote:

You can call it a couple of ways...See below.
I prefer using the 'Shell' option. A LOT less messy.
HTH,
Gary Brown

'/===================================/
Sub test_Shell()
Dim strAccessProgramLocation As String
Dim retVal As Variant

'put location of MS Access program in string
strAccessProgramLocation = _
"C:\Program Files\Microsoft Office\Office\msaccess.exe"

'call MS Access from Excel
retVal = Shell(strAccessProgramLocation, vbNormalFocus)

End Sub
'/===================================/
Sub test_App()
'create a reference to...
'Microsoft Access 9.0 Object Library
' Probably located at...
' C:\Program Files\Microsoft Office\Office\MSACC9.OLB
Dim objAccess As Access.Application

Set objAccess = New Access.Application

objAccess.Visible = True

MsgBox "Access Closed"

exit_Sub:
Set objAccess = Nothing
Exit Sub

End Sub
'/===================================/


"jojo" wrote:

I'm new to VB programming in Excel. I've coded VB in Access before but never
in Excel. I don't even know where this would be coded in Excel. I would
like to open an Access Database from Excel but don't where to even begin to
start! Can someone give me some pointers (in simple terms, as I am not
familiar with the excel programming lingo yet). Or even suggest a website
where I can find step by step instructions? I appreciate any assistance that
can be provided!!