Unable to click the MS Forms button that is on Excel Sheet

Hi All

I found one solution that will click on Excel button(MS Form CommandButton). Below is the code in C# that will fire click event of an excel button

using System;

using System.Collections.Generic;

using System.Text;

using Excel = Microsoft.Office.Interop.Excel;

using VBIDE = Microsoft.Vbe.Interop;

using System.Diagnostics;

using System.Runtime.InteropServices;

using System.Reflection;

using System.Threading;

public static bool ClickExcelButton(Excel.Worksheet excelWorksheet, string buttonName)

{

Excel.OLEObject button;

bool status = false;

try

button = (Excel.OLEObject)excelWorksheet.OLEObjects(buttonName);

if (button.Visible == true)

{

button.Activate();

button.Application.SendKeys(" ", true);

status = true;

}

if (button != null)

{

Marshal.ReleaseComObject(button);

button = null;

}

return status;

}

catch (Exception ex)

{

Console.WriteLine("Exception occured in ClickExcelButton: " + ex.Message);

status = false;

return status;

}

}

Thanks & Regards

Sunil Kumar Sinha

SunilSinha at 2007-9-4 >

Below is the source code to trap the click event of Excel button.

public static object FindControl(string name, Excel.Worksheet sheet)

{

Excel.OLEObject theObject;

try

theObject = (Excel.OLEObject)sheet.OLEObjects(name);

return theObject.Object;

}

catch (Exception ex)

{

// Returns null if the control is not found.

Console.WriteLine(ex.Message);

return null;

}

}

void MainFunction()

{

string buttonName = "cmdImportResources";

MSForms.CommandButton cmdAddResource = (MSForms.CommandButton)FindControl(buttonName, wsBudget);

cmdAddResource.Caption = "Changed";

if (cmdAddResource != null)

{

cmdAddResource.Click += new Microsoft.Vbe.Interop.Forms.CommandButtonEvents_ClickEventHandler(cmdAddResource_Click);

}

}

SunilSinha at 2007-9-4 >