Accesing an Excel button while in MS Access

[keirnus]

Hello,

I'm just wondering if this is possible.

Is it possible for MS Access to call the
OnClick function of a button in an Excel file?

Got two very important buttons in Excel file.
The user always accessing the Excel file to
click these buttons and returns to Access.
(The Access application is the main actor on this film.)

If it is possible to access the OnClick function,
I can simply call it in the Access application.
The user won't have to check the Excel file but
to remain in Access and do everything he/she needs.
I won't have to make any changes on the Excel macro codes
which will prevent mistakes and saves time as well.

Paging the Access Gurus for good tips and advices.

 

[georgedwilkinson]

Just use an Excel automation object's application ".Run" method to call the button's "_Click()" event.