Running A Access Macro From Excel

F

Frank

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?
 
P

papou

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
 
Top