Access and Excel talking

G

GJR3599

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 and excel 0
Excel and Access talking 0
Embed the same Excel multiple times 0
Call Access macro using Excel VBA 1
Word macro that can call cells out of Excel for a find and replace 0
VBA Coding Help for Beginner 0
How to create portable Excel applications? 2
Export Cross tab Query results to excel 8

Top