Open Access From A Macro

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

Greetings,

Can anyone tell me how to use an Excel macro to open an
Access database? TIA

Jamie
 
Dim acApp As Access.Application
Set acApp As New Access.Application
acApp.OpenCurrentDatabase "C:\path\myData.mdb"
..
..
Steve
 
Thanks, Steve . . .very much appreciated.
-----Original Message-----
Dim acApp As Access.Application
Set acApp As New Access.Application
acApp.OpenCurrentDatabase "C:\path\myData.mdb"
..
..
Steve





.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
How to call Excel add-in macro from a button… 1
Run MS Excel Macro From MS Access 2
Unwanted workbooks on startup 2
Automating macro to run macro from Access 3
How to call module function or sub from the Add In? 3
Access Command to run access, open to specific form and specific record 1
Difficulty opening Access from within Excel 2

Back
Top