Launch Macro in Access via Macro running in Excel???

[dgrant]

Hi all,
I need some help please..

The concept is sound however the practical side of this is confounding
us. Could anyone advise (or if possible provide code) that would allow
us to have a macro/module in an excel that went about doing some number
crunching in excel and then calls and activates a macro/or module
within access and then returned to complete the excel macro/module?

Thank you for taking the time to consider this.

 

[Tom Ogilvy]

http://support.microsoft.com/?id=177760
VBA: How to Run Macros in Other Office Programs


http://support.microsoft.com/?id=210111
ACC2000: Using Microsoft Access as an Automation Server

http://support.microsoft.com/?id=253338
INFO: Office Developer Samples and Tools Available for Download

http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available