Runing Access Module Code From Excel

[Charles]

Good Morning all
I am trying to run code that needs to be in an access mdb
from Excel, can someone tell me if this can be done I have
looked at the help files but found no answer there?.
TIA
Charles

 

[Michael Bednarek]

Good Morning all
I am trying to run code that needs to be in an access mdb
from Excel, can someone tell me if this can be done I have
looked at the help files but found no answer there?.

I found the easiest method is through a Shell command, just the same way
you would run it from the command line, something like:
msaccess /x yourmacro

Then again, you could probably also create a Microsoft Access
application object and control the execution of your code through that.