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

  • Thread starter Thread starter John Ortt
  • Start date Start date
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
 
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
 
Back
Top