Jim J
Posts: 17
Joined: 2019-03-26
|
You should be able to reproduce the issue in Excel 2016 64-bit by doing the following.
1.)Options-->General--> unchecking the "Show the Start screen when this application starts".
2.)Options-->Save--> check the "Don't show the Backstage when opening or saving files with keyboard shortcuts".
3.)Create a new ADX COM Addin
4.)Register the addin and start Excel. The addin should load and a blank workbook should appear immediately.
5.)Close Excel.
6.)Unregister the addin.
7.)Add an ADX XLL Module.
8.)Re-Register the Addin and start Excel. A blank workbook no longer appears at startup.
This issue does not happen when using Excel 2013 32bit.
My exact version of Excel is "Microsoft Excel 2016 MSO(16.0.11328.20220) 64-bit".
Below is my adxloader log file.
Add-in Express Loader Log File: 03/26/2019 23:09:32:603
Startup directory: C:\Users\Jim\Documents\Visual Studio 2017\Projects\TestAddin\TestAddin\bin\Debug\
Loader version: 9.2.4635.0
Operating System: Microsoft Windows 10 Enterprise Edition (build 17763), 64-bit
Process Owner: Administrator
Command Line: "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE"
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
------------------------------------------------------------------------
23:09:32:603 2840 0352 The minimum supported Office version is 10
23:09:32:603 2840 0352 The host's version is 16.0.11328.20222
23:09:32:603 2840 0352 Creating a new instance of the XLL loader.
23:09:32:603 2840 0352 Loading mscoree.dll
23:09:32:603 2840 0352 INFO: Assembly codebase - C:\Users\Jim\Documents\Visual Studio 2017\Projects\TestAddin\TestAddin\bin\Debug\TestAddin.dll.
23:09:32:603 2840 0352 INFO: Assembly version - 1.0.0.0.
23:09:32:603 2840 0352 Success.
23:09:32:603 2840 0352 Getting the CLSID of the managed XLL class.
23:09:32:603 2840 0352 Success.
23:09:32:603 2840 0352 Loading the configuration from the system registry.
23:09:32:603 2840 0352 Getting the latest CLR version.
23:09:32:603 2840 0352 The latest CLR version is 'v4.0.30319'.
23:09:32:603 2840 0352 The configuration has been loaded successfully.
23:09:32:619 2840 0352 Runtime version: v4.0.30319.
23:09:32:619 2840 0352 Assembly name: TestAddin, PublicKeyToken=c13acbcdead6de17.
23:09:32:619 2840 0352 Class name: TestAddin.XLLTestAddinUDFs.
23:09:32:619 2840 0352 Registry key: CLSID\{9F4231C7-F2D7-3E8D-A6C2-26C583DF27A0}.
23:09:32:619 2840 0352 Attempting to create a new instance of the managed XLL class: CLR - v4.0.30319
23:09:32:619 2840 0352 Loading CLR: v4.0.30319.
23:09:32:619 2840 0352 Calling CLRCreateInstance method.
23:09:32:619 2840 0352 Success.
23:09:32:619 2840 0352 Calling GetRuntime method.
23:09:32:619 2840 0352 Success.
23:09:32:619 2840 0352 Checking if the hosting API of .NET Framework v4.0 beta is installed.
23:09:32:634 2840 0352 The hosting API is up to date.
23:09:32:634 2840 0352 Calling SetDefaultStartupFlags method.
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Calling GetInterface method for the CorRuntimeHost interface.
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Starting CLR...
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Getting the CLR version.
23:09:32:634 2840 0352 The CLR v4.0.30319 has been initialized successfully.
23:09:32:634 2840 0352 Creating a new domain setup.
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Getting the add-in directory.
23:09:32:634 2840 0352 Success. The directory is 'C:\Users\Jim\Documents\Visual Studio 2017\Projects\TestAddin\TestAddin\bin\Debug\'
23:09:32:634 2840 0352 The 'shadow copy' is disabled.
23:09:32:634 2840 0352 Creating a new application domain.
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Getting the base directory for the domain.
23:09:32:634 2840 0352 Success. The directory is 'C:\Users\Jim\Documents\Visual Studio 2017\Projects\TestAddin\TestAddin\bin\Debug\'.
23:09:32:634 2840 0352 Opening adxloader.dll.manifest.
23:09:32:634 2840 0352 Success. The manifest is 'C:\Users\Jim\Documents\Visual Studio 2017\Projects\TestAddin\TestAddin\bin\Debug\adxloader.dll.manifest'.
23:09:32:634 2840 0352 Getting the 'assemblyIdentity' element.
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Getting the 'name' attribute.
23:09:32:634 2840 0352 Success. The name is 'TestAddin, PublicKeyToken=c13acbcdead6de17'.
23:09:32:634 2840 0352 Getting the 'name' attribute.
23:09:32:634 2840 0352 Success. The class name is 'TestAddin.XLLTestAddinUDFs'.
23:09:32:634 2840 0352 Attempting to create a new instance of the XLL class.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoOpen' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoClose' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoAdd' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoRemove' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoFree' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoFree12' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'addInManagerInfo' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'addInManagerInfo12' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'Dispose' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'initialize4' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Invoking the 'initialize4' method.
23:09:32:760 2840 0352 Success.
23:09:32:760 2840 0352 The instance of the managed XLL class has been created successfully.
23:09:32:760 2840 0352 Forwarding xlAutoOpen to the managed code.
23:09:32:775 2840 0352 Success.
23:09:32:791 2840 0352 Start.
23:09:32:791 2840 0352 The minimum supported Office version is 10
23:09:32:791 2840 0352 The host's version is 16.0.11328.20222
23:09:32:791 2840 0352 Creating a new instance of the add-in loader.
23:09:32:791 2840 0352 Success.
23:09:32:791 2840 0352 Loading the configuration from the system registry.
23:09:32:791 2840 0352 Getting the latest CLR version.
23:09:32:791 2840 0352 The latest CLR version is 'v4.0.30319'.
23:09:32:791 2840 0352 The configuration has been loaded successfully.
23:09:32:791 2840 0352 Runtime version: v4.0.30319.
23:09:32:791 2840 0352 Assembly name: TestAddin, PublicKeyToken=C13ACBCDEAD6DE17.
23:09:32:791 2840 0352 Class name: TestAddin.AddinModule.
23:09:32:791 2840 0352 Registry key: CLSID\{322A357C-C31C-47FC-A442-94D869CDFF25}.
23:09:32:791 2840 0352 Attempting to create a new instance of the managed add-in class: CLR - v4.0.30319
23:09:32:791 2840 0352 Creating an instance of the managed class. Assembly identity: 'TestAddin, PublicKeyToken=C13ACBCDEAD6DE17'
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Unwrapping the managed class.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Querying the add-in extensibility.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Querying the custom task panes.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Querying the ribbon extensibility.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Querying the form regions.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Querying the encryption provider.
23:09:32:806 2840 0352 The 'EncryptionProvider' interface is not supported.
23:09:32:806 2840 0352 Getting the dispid of the 'Dispose' method.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Getting the dispid of the 'InitializeLoaderService' method.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Invoking the 'InitializeLoaderService' method.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 The instance of the managed add-in class has been created successfully.
23:09:40:197 2840 0352 Forwarding xlAddInManagerInfo12 to the managed code.
23:09:40:213 2840 0352 Success.
23:09:46:884 2840 0352 Forwarding xlAutoClose to the managed code.
23:09:46:884 2840 0352 Success. |
|
Dmitry Kostochko
Add-in Express team
Posts: 2875
Joined: 2004-04-05
|
|
Jim J
Posts: 17
Joined: 2019-03-26
|
Thanks for the quick reply Dmitry.
The links you provided were helpful and now that I know this is an Excel 2016 bug I will file it for my records.
Thanks,
Jim |
|
Dmitry Kostochko
Add-in Express team
Posts: 2875
Joined: 2004-04-05
|
Hi Jim,
Thank you for keeping us informed. |
|