Learning from a Visual Studio Tools for Office book

Question

Learning from a Visual Studio Tools for Office book

John 506

I have a book titled, "Visual Studio Tools for Office", but it was published in 2006.

So many changes may have been made to the VSTO framework since then.

Here is an example out of this book.

It is in a class file, but it will not sense correctly.

Which returning type of class would I need to make it work, and would I need to do these in an Add-in, workbook, or template for VSTO?

using Excel = Microsoft.Office.Interop.Excel;

class SampleListener
{
	private Excel.Application app;
	
	public SampleListener(Excel.Application application)
	{
		app = application
	}

	public void ConnectEvents()
	{
		app.WorkbookOpen += new AppEvents_WorkbookOpenEventHandler(this.MyOpenHandler);
	}

	public void DisconnectEvents()
	{
		
		app.WorkbookOpen -= new AppEvents_WorkbookOpenEventHandler(this.MyOpenHandler);

	}

	public void MyOpenHandler(Excel.Workbook workbook)
	{
		MessageBox.Show(String.Format("{0}" was opened. ", workbook.Name);
	}

}

John 506 Reputation points

2023-05-24T16:23:13.6433333+00:00

Sadly, there are hardly any download or paperback books for these tutorials.

John 506

I have tried to run this updated code snippet, and nothing has worked.

By the way, this code snippet will not be compiled, and it needs to be looked at.


using System;
using System.Data;
using System.Drawing;
using System.Security.Cryptography.X509Certificates;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
using Microsoft.VisualStudio.Tools.Applications.Runtime;
using Excel = Microsoft.Office.Interop.Excel;
using Office = Microsoft.Office.Core;

namespace SampleListener
{
    public delegate void AppEvents_WorkbookOpenEventHandler(Workbook wb);

    
    public partial class ThisWorkbook
    {

        private Excel.Application app;


        private void ThisWorkbook_Startup(object sender, System.EventArgs e)
        {
           

        }

        private void ThisWorkbook_Shutdown(object sender, System.EventArgs e)
        {
        }

        public void MyOpenHandler(Excel.Workbook wb)
        {
            MessageBox.Show(wb.Name + " was opened. ");
        }

        public void SampleListener(Excel.Application application)
        {
            app = application;

        }

        public void ConnectEvents()
        {
            app.WorkbookOpen += new AppEvents_WorkbookOpenEventHandler(this.MyOpenHandler);

        }
 
        public void DisconnectEvents()
        {
            app.WorkbookOpen -= new AppEvents_WorkbookOpenEventHandler(this.MyOpenHandler);
        }
            #region VSTO Designer generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InternalStartup()
        {
            this.Startup += new System.EventHandler(ThisWorkbook_Startup);
            this.Shutdown += new System.EventHandler(ThisWorkbook_Shutdown);
        }
 
        #endregion

    }
}

Your answer

John 506 Reputation points

2023-05-24T16:23:13.6433333+00:00

Sadly, there are hardly any download or paperback books for these tutorials.
John 506 Reputation points

2023-05-24T17:59:40.3366667+00:00

I have tried to run this updated code snippet, and nothing has worked.

By the way, this code snippet will not be compiled, and it needs to be looked at.

using System; using System.Data; using System.Drawing; using System.Security.Cryptography.X509Certificates; using System.Windows.Forms; using Microsoft.Office.Interop.Excel; using Microsoft.VisualStudio.Tools.Applications.Runtime; using Excel = Microsoft.Office.Interop.Excel; using Office = Microsoft.Office.Core; namespace SampleListener { public delegate void AppEvents_WorkbookOpenEventHandler(Workbook wb); public partial class ThisWorkbook { private Excel.Application app; private void ThisWorkbook_Startup(object sender, System.EventArgs e) { } private void ThisWorkbook_Shutdown(object sender, System.EventArgs e) { } public void MyOpenHandler(Excel.Workbook wb) { MessageBox.Show(wb.Name + " was opened. "); } public void SampleListener(Excel.Application application) { app = application; } public void ConnectEvents() { app.WorkbookOpen += new AppEvents_WorkbookOpenEventHandler(this.MyOpenHandler); } public void DisconnectEvents() { app.WorkbookOpen -= new AppEvents_WorkbookOpenEventHandler(this.MyOpenHandler); } #region VSTO Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InternalStartup() { this.Startup += new System.EventHandler(ThisWorkbook_Startup); this.Shutdown += new System.EventHandler(ThisWorkbook_Shutdown); } #endregion } }

Share via

Learning from a Visual Studio Tools for Office book

Your answer