I found in the forum a way to call an Access macro from Excel:
http://vbforums.com/showthread.php?&...00#post1907700
But how can I call a procedure embeded in some module in Access from Excel?
Printable View
I found in the forum a way to call an Access macro from Excel:
http://vbforums.com/showthread.php?&...00#post1907700
But how can I call a procedure embeded in some module in Access from Excel?
I have been trying to use Docmd.RunCode but it doesn't recognize .RunCode like a valid method.
I'm not sure whether you can do what you want or not. You can automate Access from Excel, which would allow you to use Access methods, functions, etc. But I don't know if you can get at user created subs.
Try a search on Access automation.