Running A Access Macro From Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please can someone help? I have a Macro in Access But I need to run it from
within Excel using VBA code.
Is this possible?
 
Hello Frank
Yes this is possible using OLE:
Requires a reference to Microsoft Access n.0 Object Library where n is
version number of Access
Dim ObjAcc As Access.Application
Set ObjAcc = CreateObject("Access.Application")
ObjAcc.OpenCurrentDatabase "D:\Mes
Documents\Pascal\Office\Access\DonneesNew.mdb"
ObjAcc.UserControl = True
AppActivate "Microsoft Access"
ObjAcc.Run ("MacroName")
Set ObjAcc = Nothing

HTH
Cordially
Pascal
 
ActiveX component can't create object? is there another way of doing this.
Frank
 
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
Run Access Macro from Excel 1
How to call Excel add-in macro from a button… 1
Refresh Macro to run each day? 2
Run MS Excel Macro From MS Access 2
Programatically changing the macro content. 1
VBA code won't run, even with Macro Security set to Enable All Macors 9
Open MS Access Database and running it's maco from Excel 1

Back
Top