How to click existing command Button in an excel

[Anonymous]

We have one command button in excel sheet1. We need to click on Command Button at run time to read the data of Sheet2. We tried with the "Run Macro" command but no Success Please suggest some way

[robin_wylie]

use ""Sheet1.MacroName"" Macros embedded within a sheet need to have the sheetname in front of it. Macros in a module do not.    

[BenKirimlidis]

Can also use the sub below to run macros.  Just add this into a module and it will run when the excel file is opened.  One less step in Blue Prism.   Sub Auto_Open()     '   Open message box when excel file is opened     MsgBox ""Hello,World!"" End Sub