CODEWITHSUNDEEP
c#excelvsto
Rav
Rav

Reputation: 97

Excel VSTO NewWorkbook event doesn't occur on startup

I'm developing an Excel 2010 application-level addin. I need to write handlers for some of the Application events connected with the Workbook interface, especially NewWorkbook event.

So in ThisAddIn_Startup handler I added code like this:

Microsoft.Office.Interop.Excel.AppEvents_Event app = Globals.ThisAddIn.Application;
app.NewWorkbook += MyApp_NewWorkbook;

It works fine when the new Workbook is created within running Excel instance. But when I run new Excel instance (which, in standard cases, implies creating new Workbook) this event isn't catched by my handler. I suppose then that when I run new Excel instance the NewWorkbook event occurs before the ThisAddIn_Startup event.

In case of the WorkbookOpen event application behaves just like I would expect - event is catched when I open existing Workbook within the running Excel instance as well as when I just double-click the file. I'm wondering why these events are handled differently?

What should I do in this case? I need to recognize if a new Workbook was created or an existing one was opened regardless of whether Excel is already running or not.

Upvotes: 4

Views: 1443

Answers (2)

Kiru
Kiru

Reputation: 3565

In the WorkbookOpen event check for 

string.IsNullOrEmpty(application.ActiveWorkbook.Path)

which means your workbook is never saved. All the new workbook created when you open the Excel will be true for the above line.

Upvotes: 1

Chris Spicer
Chris Spicer

Reputation: 2194

How about performing your action on all the workbooks that are open when your add-in loads?

Something like the following in the ThisAddIn_Startup handler? (no IDE here, so written by hand):

foreach (var workbook in Globals.ThisAddIn.Application.Workbooks)
{
  // Do your thing
}

Then use your event handling to catch any workbooks that open subsequently.

Upvotes: 1

Related Questions