Execute Excel Macros From Access?
Posted by JohnH on June 26, 2001 7:49 AM
Can I call and execute Macros (in the Excel Workbook) from my application in Access? If so how do I go about this?
Basicaly, I want to call execute a Macro in my Excel workbook that transfers data from one worksheet to another, then transfer this new data into my Access Database and then delete the records in my Excel Worksheet so the whole process can repeat itself as needed in the future. The Excel workbook is being updated by various users and it is basically a holding tank for the Access Database.