Tony,
Thanks for the quick response.
I get a VBA compile error "Method or data member not defined" when I enter database.DoCmd.RunMacro "MacroName" . In my subroutine, I've dimensioned my database (EC.mdb) as a database, and opened it using DBEngine.OpenDatabase . I'm...
I would like to run an Access macro from an Excel/VBA app. I'm able to run Access update queries from VBA using database.Execute queryname. Is there a similar way to run an Access macro?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.