Problem trigger Excel ActiveX button from another Windows Forms App

Question

I receipt requirement about autorun Excel macro program but I familiar only Windows Forms App. I have tried Microsoft.Office.Interop.Excel to activate buttons. Its not works.

public bool openFileExcel(string filename)
        {
            Excel.Application _xlsm = new Excel.Application();
            Excel.Workbook _xlsB = _xlsm.Workbooks.Open(_fPath + filename);
            _xlsm.Visible = true;
            Excel.Worksheet _xlsS = _xlsB.Worksheets["Control"];
            Excel.OLEObject _oObj = _xlsS.OLEObjects("m_btnReset");

            _xlsm.AutomationSecurity = MsoAutomationSecurity.msoAutomationSecurityForceDisable;
            if (_xlsm.Ready)
            {
                try
                {
                    _oObj.Select();
                    _oObj.Activate();
                }
                catch(Exception e)
                {
                    MessageBox.Show(e.Message);
                }
                return false;
            }
            else
            {
                return false;
            }
        }

Please guiding me.

Answer 1

@Piyaphruk , based on my test, you could try to use the Property _oObj.Object.Value = true ; to trigger the excel activex Button from Winform app.

Here is a code example you could refer to.

private void button1_Click(object sender, EventArgs e)  
        {  
            string xlFileName = Path.Combine("D:\\", "test1.xlsm");  
            var xlApp = new Excel.Application();  
            var xlWorkbook = xlApp.Workbooks.Open(xlFileName);  
            var xlSheet = xlWorkbook.Worksheets["Sheet1"] as Excel.Worksheet;  
            Excel.OLEObject _oObj = xlSheet.OLEObjects("CommandButton1");  
           _oObj.Object.Value = true ;     // This code will trigger the button  
            xlWorkbook.Save();  
            xlWorkbook.Close();  
  
            Marshal.ReleaseComObject(xlWorkbook); xlWorkbook = null;  
            Marshal.ReleaseComObject(xlApp); xlApp = null;  
  
  
        }  

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.