ExcelDna icon indicating copy to clipboard operation
ExcelDna copied to clipboard

First book created is called Book2 when ribbon add-in installed

Open govert opened this issue 5 years ago • 1 comments

When an Excel-DNA add-in with a ribbon is installed into Excel, it creates (and then closes) a hidden workbook during loading in an attempt to get hold of the Application COM object. A side-effect of this is that the first book created is called "Book2" which is often a sign to the user that "something is wrong". It would be good to either find a mechanism that gets hold of the Application object without this side effect, or implement some kind of delay loading that gives Excel a chance to create the Application object itself before the add-in is loaded.

/cc @augustoproiete This is a tricky one, but related to where you have been looking.

govert avatar Nov 02 '19 07:11 govert

Revisit this issue in the light of this discussion: https://groups.google.com/g/exceldna/c/u4kmDlLn614

govert avatar Jul 20 '20 18:07 govert