Power Code - Handle Sleep & Suspension Excel C# code to reload an Excel add-in, although this should work for any office product, upon waking from suspend on Windows 7

PowerRelatedCode.cs

        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            SystemEvents.PowerModeChanged += OnPowerChange;  
        }

        void OnPowerChange(Object sender, PowerModeChangedEventArgs e)
        {
            switch (e.Mode)
            {
                case PowerModes.Resume:

                    //you method here, for restoring connection after sleep
                    ReloadTaskPaneMethod();

                    break;

                case PowerModes.Suspend:

                    //no need to do anything to subscriber on suspend, unless your code needs to
                    break;
            }
        }

        private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
        {
            SystemEvents.PowerModeChanged -= OnPowerChange;  
        }