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

[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

 

[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