none
[Excel]Need to Track ExcelWorkBook Opening Event From a vsto addin RRS feed

  • General discussion

  • I need to show the custom ribbon created using vsto when some template is open in excel file? So that I am thinking to do it find out some range in the template if it is existing show the ribbon. For that i need to track WorkBook Staring event... Is there any way to do it?????
    Friday, July 12, 2013 12:39 PM

All replies

  • Which programming language do you work in, and which version of Office and VSTO are you targeting?

    Cindy Meister, VSTO/Word MVP, my blog

    Saturday, July 13, 2013 1:30 PM
    Moderator
  • VB.Net is the programming language For excel 2007 and .net 4.0
    Monday, July 15, 2013 5:37 AM
  • Hi Shabeer

    OK, I'm assuming this is an Excel Add-in...

    View the ThisAddIn.vb code module. Click on the dropdown at the top, left of the code window and choose "Application". Then click on the dropdown at the top, right of the code window and choose WorkbookOpen.

    Visual Studio will insert the code stub for the WorkbookOpen event of the Excel application. You write your code inside that procedure that should take place whenever an existing workbook is opened in the Excel application.


    Cindy Meister, VSTO/Word MVP, my blog

    Monday, July 15, 2013 3:20 PM
    Moderator