C#

public class TestClass
{
    /// <summary>
    /// Field to hold class instance.
    /// </summary>
    private ClassWithEvent classWithEvent;

    /// <summary>
    /// Initializes a new intance of TestClass.
    /// </summary>
    public TestClass()
    {
        // Instanciate classWithEvent
        classWithEvent = new ClassWithEvent();
        // Subscribe to the classWithEvent.Event, the method in brackets will be called when it is raised
        classWithEvent.Event += new EventHandler(classWithEvent_Event);
    }

    /// <summary>
    /// Method called when classWithEvent.Event is raised
    /// </summary>
    /// <param name="sender">The ClassWithEvent instance that raised the event.</param>
    /// <param name="e">The EventArgs instance that was sent with the event.</param>
    void classWithEvent_Event(object sender, EventArgs e)
    {
        // Do what you need to do here!
        Console.WriteLine("Event Rased!");
    }
}

public class ClassWithEvent
{
    /// <summary>
    /// This is the event!
    /// </summary>
    public event EventHandler Event;

    /// <summary>
    /// This method actually raises the event.
    /// </summary>
    /// <param name="e">The arguments class that holds any data relating to the event.</param>
    protected virtual void OnEvent(EventArgs e)
    {
        // Create a copy...
        EventHandler eh = Event;
        // Null check as eh will be null if no subscribers
        if (eh != null)
            eh(this, e);
    }

    /// <summary>
    /// This public method is just by way of example. This could be any method, property setter etc...
    /// </summary>
    public void PerformEvent()
    {
        // Call the method that actually raises the event
        OnEvent(EventArgs.Empty);
    }
}

[DllImport("user32.dll", CallingConvention=CallingConvention.StdCall, SetLastError=true)]
public static extern IntPtr SendInput(int count, ref INPUT input, int size);

• It breaks the principles of client / server architecture. If you want to access a common object you should only do this on the server via method calls. There are several ways of persisting the common object between calls / clients
• By attempting to call methods/set properties on an object instanced on the server from the client, you are opening up a security hole

myExcelAppObject.Worksheets...

antsims wrote:

What is the easiest way to activate a specific excel worksheet within a workbook.