Excel and Access talking
 

Basically I am wondering how I can get excel macros to call access macros or
vice versa. Specifically I am looking for a way to have a macro built that
can liase between Excel and Access. Ultimately I would like to have a macro
that populates a data sheet in Excel (by pulling data from multiple Excel
files), opens Access and runs the Access macro that pulls the aforementioned
Excel sheet. An alternative would be to have an Access macro that opens up
multiple Excel docs, runs certain functions within those workbooks and then
enacts the Access macro.