run command button in Access from excel

Hi,

I am currently trying to create a macro that will run a command button from excel. Currently having some trouble.

Can someone please advise?

The command button is in Form_frmMain
the code in there is called Public Sub cmdrun_report_Click()

this is what I currently have to try and open and call this button.

Please Login or Register  to view this content.

Instead or running the form.button
run the macro that the button runs. docmd.runmacro "macro"