call excel macro from access
 

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

--
Message posted from http://www.ExcelForum.com

call excel macro from access
 

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


--
Regards,
Tom Ogilvy

"banavas " wrote in message
...
Dear friends,

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

Thanks,
G.


---
Message posted from http://www.ExcelForum.com/