Run activex command button via macro

Sir, i am attaching a file excel tally in which in sheet s-c-voucher one generate button is there.
i want to run the code behind it via macro to be recorded in different workbook.
kindly help me.

Thanks,

Something like......

I haven't tested this

Please Login or Register  to view this content.

probably best to call a sub from the button, and then call this sub from the Run("") more descript and unique than CommandButton1_Click()

Sir,
I am new to macro and vb so please elaborate this.

Thanks,