call excel macro from access

[banavas]

Dear friends,

How can I call a specific Macro (ex. macro) of Data.xls by clicking
button in Access? Do you have any code for that?

Thanks,
G

 

[Tom Ogilvy]

http://support.microsoft.com/?kbid=177760
VBA: How to Run Macros in Other Office Programs
The above is for access

http://support.microsoft.com/?kbid=165518
Calling Macros Using OLE from MS Visual Basic for Applications