Running a macro in Access from a button Excel (and vice versa)

J

John Ortt

Does anybody know of a way to run a macro in access from a command button in
excel?

Any pointers are greatly appreciated,

Thankyou.

John Ortt
 
A

Alex Dybenko

You can make a public function in Access which run your macro, then create
instance of access in excel:
set acc=createobject("Access.application")
open your database using opencurrentdatabase method
and then use run method of acc object to run your public function
 
Top