Tag: dialog

using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Runtime.InteropServices;
using System.Text;
using System.Threading;
using PowerPoint = Microsoft.Office.Interop.PowerPoint;
using Excel = Microsoft.Office.Interop.Excel;
using Word = Microsoft.Office.Interop.Word;

namespace OfficeExtensions
{
    public static class OfficeExtensions
    {
        public delegate void AfterPowerPointSaveHandler(PowerPoint.Presentation PobjPres);
        public delegate void AfterWordSaveHandler(Word.Document PobjDoc);
        public delegate void AfterExcelSaveHandler(Excel.Workbook PobjWb);
        private const int MCintDELAY = 1000;

        /// <summary>
        /// POWERPOINT EXTENSION METHOD - AFTER SAVE
        /// This function allows you to pass in a function that you want to
        /// have called after PowerPoint has completed a SaveAs. If the user
        /// only performs a save, your method will not be called. This only
        /// gets called when the Save As Dialog is used.
        /// </summary>
        /// <param name="PobjApp"></param>
        /// <param name="PobjFunc"></param>
        public static void AttachToPowerPointAfterSaveAsEvent(this PowerPoint.Application PobjApp, AfterPowerPointSaveHandler PobjFunc)
        {
            // FIRST - we attach to the BeforeSave event
            PobjApp.PresentationBeforeSave += (PowerPoint.Presentation PobjPres, ref bool PbolCancel) =>
            {
                // start a new thread using LAMBDA
                new Thread(() =>
                {
                    Thread.Sleep(MCintDELAY); // need this delay
                    if (hasSaveAsDialogOpen())
                    {
                        while (hasSaveAsDialogOpen())
                        {
                            Thread.Sleep(1);
                            System.Windows.Forms.Application.DoEvents();
                        }
                        // look for the saveAs dialog and as long as it
                        // is open we will wait right here
                        PobjFunc.Invoke(PobjPres);
                    }
                }
                ).Start();
            };
        }

        /// <summary>
        /// WORD EXTENSION METHOD - AFTER SAVE
        /// This function allows you to pass in a function that you want to
        /// have called after Word has completed a SaveAs. If the user
        /// only performs a save, your method will not be called. This only
        /// gets called when the Save As Dialog is used.
        /// </summary>
        /// <param name="PobjApp"></param>
        /// <param name="PobjFunc"></param>
        public static void AttachToWordAfterSaveAsEvent(this Word.Application PobjApp, AfterWordSaveHandler PobjFunc)
        {
            // FIRST - we attach to the BeforeSave event
            PobjApp.DocumentBeforeSave += (Word.Document PobjDoc, ref bool PbolSaveAsUi, ref bool PbolCancel) =>
            {
                // start a new thread using LAMBDA
                new Thread(() =>
                {
                    Thread.Sleep(MCintDELAY); // need this delay
                    if (hasSaveAsDialogOpen())
                    {
                        while (hasSaveAsDialogOpen())
                        {
                            Thread.Sleep(1);
                            System.Windows.Forms.Application.DoEvents();
                        }
                        // look for the saveAs dialog and as long as it
                        // is open we will wait right here
                        PobjFunc.Invoke(PobjDoc);
                    }
                }
                ).Start();
            };
        }

        /// <summary>
        /// EXCEL EXTENSION METHOD - AFTER SAVE
        /// This function allows you to pass in a function that you want to
        /// have called after Excel has completed a SaveAs. If the user
        /// only performs a save, your method will not be called. This only
        /// gets called when the Save As Dialog is used.
        /// </summary>
        /// <param name="PobjApp"></param>
        /// <param name="PobjFunc"></param>
        public static void AttachToExcelAfterSaveAsEvent(this Excel.Application PobjApp, AfterExcelSaveHandler PobjFunc)
        {
            // FIRST - we attach to the BeforeSave event
            PobjApp.WorkbookBeforeSave += (Excel.Workbook PobjWb, bool PbolSaveAsUi, ref bool PbolCancel) =>
            {
                // start a new thread using LAMBDA
                new Thread(() =>
                {
                    Thread.Sleep(MCintDELAY); // need this delay
                    if (hasSaveAsDialogOpen())
                    {
                        while (hasSaveAsDialogOpen())
                        {
                            Thread.Sleep(1);
                            System.Windows.Forms.Application.DoEvents();
                        }
                        // look for the saveAs dialog and as long as it
                        // is open we will wait right here
                        PobjFunc.Invoke(PobjWb);
                    }
                }
                ).Start();
            };
        }

        #region API CODE
        [DllImport("user32.dll", SetLastError = true, CharSet = CharSet.Auto)]
        private static extern IntPtr FindWindowEx(IntPtr parentHandle, IntPtr childAfter, string className, string windowTitle);

        [DllImport("user32.dll", SetLastError = true)]
        private static extern uint GetWindowThreadProcessId(IntPtr hWnd, out uint lpdwProcessId);

        /// <summary>
        /// Helper function to see if Word has any dialogs open
        /// </summary>
        /// <returns></returns>
        private static bool hasSaveAsDialogOpen()
        {
            const string LCstrWIN_CLASS = "#32770";
            const string LCstrWIN_CAPTION = "Save As";
            IntPtr LintHWin = IntPtr.Zero;
            LintHWin = FindWindowEx(IntPtr.Zero, LintHWin, LCstrWIN_CLASS, LCstrWIN_CAPTION);
            uint PID = 0;
            while (LintHWin != IntPtr.Zero)
            {
                // Make sure that the  window handle that we got is for the current running
                // Office Application process. We do this by checking if the PID for this window 
                // our Office application are the same.
                GetWindowThreadProcessId(LintHWin, out PID);
                if (PID == Process.GetCurrentProcess().Id)
                    break; // found it and it belongs to our app
                // get next window
                LintHWin = FindWindowEx(IntPtr.Zero, LintHWin, LCstrWIN_CLASS, LCstrWIN_CAPTION);
            }
            return LintHWin != IntPtr.Zero;
        }
        #endregion
    }
}

/// <summary>
/// STARTUP
/// </summary>
/// <param name="PobjSender"></param>
/// <param name="PobjEventArgs"></param>
private void ThisAddIn_Startup(object PobjSender, System.EventArgs PobjEventArgs)
{
    // Attach a method to the Extension methods After Before Save As event
    // in this case we are doing  LAMBDA expression
    Application.AttachToPowerPointAfterSaveAsEvent((PowerPoint.Presentation PobjPres) =>
        {
            MessageBox.Show("The filename is: " + PobjPres.FullName);
        });
}

/// <summary>
/// STARTUP
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ThisAddIn_Startup(object sender, System.EventArgs e)
{
    // Attach a method to the Extension methods After Before Save As event
    Application.AttachToExcelAfterSaveAsEvent(HandleAfterBeforeSaveAs);
}

/// <summary>
/// Handles the after SaveAs dialog
/// </summary>
/// <param name="PobjPres"></param>
private void HandleAfterBeforeSaveAs(Excel.Workbook PobjWb)
{
    MessageBox.Show("The filename is: " + PobjWb.FullName);
}