|
Matt Comstock
Guest
|
Hello,
We're upgrading our Excel add-in from 2008 to 2010, and everything has gone well as far as building and registering, however, our add-in doesn't show up in Excel 2010, and the log indicates and error loading. I copied the new adxloader and adxloader64 to my Loader project folder and renamed to include our product name (adxloader64.PerTrac.PowerLink.dll), and also updated the project reference to the new AdinExpress.MSO.2005.dll.
Here is the log contents after registering and running Excel in my development environment:
Add-in Express Loader Log File: 07/13/2010 09:43:21
Startup directory: C:\TFS\dotNet Projects\Release\PowerLink\V1.0\PerTrac PowerLink\bin\Debug\
Loader version: 6.0.3043
------------------
09:43:21 1240 4432 Start.
09:43:21 1240 4432 Reading the registry key 'HKEY_CLASSES_ROOT\CLSID\{196716C5-4CDD-484B-BF6D-C94B9AA2BD05}'
09:43:21 1240 4432 Success. The registry key 'HKEY_CLASSES_ROOT\CLSID\{196716C5-4CDD-484B-BF6D-C94B9AA2BD05}' is closed.
09:43:21 1240 4432 Converting the '{4BA250A6-8BCA-46A6-982A-F340081187C3}' CLSID from string.
09:43:21 1240 4432 Success.
09:43:21 1240 4432 Attempting to get the class object by the '{4BA250A6-8BCA-46A6-982A-F340081187C3}' CLSID.
09:43:21 1240 4432 Success.
09:43:21 1240 4432 Creating a new instance of the add-in loader.
09:43:21 1240 4432 Success.
09:43:21 1240 4432 Loading the configuration from the system registry.
09:43:21 1240 4432 Getting the latest CLR version.
09:43:21 1240 4432 The latest CLR version is 'v4.0.30319'.
09:43:21 1240 4432 The configuration has been loaded successfully.
09:43:21 1240 4432 Runtime version: v2.0.50727.
09:43:21 1240 4432 Assembly name: PerTrac.PowerLink, PublicKeyToken=1B72B137335E31C3.
09:43:21 1240 4432 Class name: PerTrac.PowerLink.PerTracPowerLink.
09:43:21 1240 4432 Attempting to create a new instance of the managed add-in class: CLR - v2.0.50727
09:43:21 1240 4432 Loading CLR: v2.0.50727.
09:43:21 1240 4432 Calling GetCLRMetaHost method.
09:43:21 1240 4432 Success.
09:43:21 1240 4432 Calling GetRuntime method.
09:43:21 1240 4432 Success.
09:43:21 1240 4432 Calling GetInterface method.
09:43:21 1240 4432 Calling GetInterface method for the CorRuntimeHost interface.
09:43:21 1240 4432 Success.
09:43:21 1240 4432 Starting CLR...
09:43:21 1240 4432 Success.
09:43:21 1240 4432 The CLR v2.0.50727 has been initialized successfully.
09:43:21 1240 4432 Creating a new domain setup.
09:43:21 1240 4432 Success.
09:43:21 1240 4432 Getting the add-in directory.
09:43:21 1240 4432 Success. The directory is 'C:\TFS\dotNet Projects\Release\PowerLink\V1.0\PerTrac PowerLink\bin\Debug\'
09:43:21 1240 4432 The configuration file is 'C:\TFS\dotNet Projects\Release\PowerLink\V1.0\PerTrac PowerLink\bin\Debug\PerTrac.PowerLink.dll.config'
09:43:21 1240 4432 The 'shadow copy' is enabled.
09:43:21 1240 4432 Creating a new application domain.
09:43:21 1240 4432 Success.
09:43:21 1240 4432 An attempt was made to load a program with an incorrect format.
Probably something simple. All help is appreciated - thanks.
- Matt - |
|
Posted 13 Jul, 2010 11:55:08
|
|
Top
|
|
Matt Comstock
Guest
|
Just wanted to add that our add-in has both UI components (using Ribbon for 2007 and command bars for 2003)and UDF components. After Excel has started and I go to File->Options->Add-Ins, I see one entry in Active Application Add-ins for the Excel add-in, and one entry in Inactive Application Add-ins for the COM add-in, indicating that it failed to load.
Related question: Do I need to use a different UI component for 2010 support?
Thanks.
- Matt - |
|
Posted 13 Jul, 2010 12:03:18
|
|
Top
|
|
Matt Comstock
Guest
|
Another addition - after starting Excel, I try to see if the XLL (UDFs) are loading, and the log gets some more content:
Add-in Express Loader Log File: 07/13/2010 09:51:18
Startup directory: C:\TFS\dotNet Projects\Release\PowerLink\V1.0\PerTrac PowerLink\bin\Debug\
Loader version: 6.0.3043
------------------
09:51:18 2020 4720 Start - xlAddInManagerInfo12.
09:51:18 2020 4720 Creating a new instance of the XLL loader.
09:51:18 2020 4720 Success.
09:51:18 2020 4720 Getting the CLSID of the managed XLL class.
09:51:18 2020 4720 Success.
09:51:18 2020 4720 Loading the configuration from the system registry.
09:51:18 2020 4720 Getting the latest CLR version.
09:51:18 2020 4720 The latest CLR version is 'v4.0.30319'.
09:51:18 2020 4720 The configuration has been loaded successfully.
09:51:18 2020 4720 Runtime version: v2.0.50727.
09:51:18 2020 4720 Assembly name: PerTrac.PowerLink, Version=1.0.22.0, Culture=neutral, PublicKeyToken=1b72b137335e31c3.
09:51:18 2020 4720 Class name: PerTrac.PowerLink.PowerLinkUserDefinedFunctions.
09:51:18 2020 4720 Attempting to create a new instance of the managed XLL class: CLR - v2.0.50727
09:51:18 2020 4720 Loading CLR: v2.0.50727.
09:51:18 2020 4720 Calling GetCLRMetaHost method.
09:51:18 2020 4720 Success.
09:51:18 2020 4720 Calling GetRuntime method.
09:51:18 2020 4720 Success.
09:51:18 2020 4720 Calling GetInterface method.
09:51:18 2020 4720 Calling GetInterface method for the CorRuntimeHost interface.
09:51:18 2020 4720 Success.
09:51:18 2020 4720 Starting CLR...
09:51:18 2020 4720 Success.
09:51:18 2020 4720 The CLR v2.0.50727 has been initialized successfully.
09:51:18 2020 4720 Creating a new domain setup.
09:51:18 2020 4720 Success.
09:51:18 2020 4720 Getting the add-in directory.
09:51:18 2020 4720 Success. The directory is 'C:\TFS\dotNet Projects\Release\PowerLink\V1.0\PerTrac PowerLink\bin\Debug\'
09:51:18 2020 4720 The configuration file is 'C:\TFS\dotNet Projects\Release\PowerLink\V1.0\PerTrac PowerLink\bin\Debug\PerTrac.PowerLink.dll.config'
09:51:18 2020 4720 The 'shadow copy' is enabled.
09:51:18 2020 4720 Creating a new application domain.
09:51:18 2020 4720 Success.
09:51:18 2020 4720 Getting the base directory for the domain.
09:51:18 2020 4720 Success. The directory is 'C:\TFS\dotNet Projects\Release\PowerLink\V1.0\PerTrac PowerLink\bin\Debug\'.
09:51:18 2020 4720 Openning adxloader.dll.manifest.
09:51:18 2020 4720 Success. The manifest is 'C:\TFS\dotNet Projects\Release\PowerLink\V1.0\PerTrac PowerLink\bin\Debug\adxloader.dll.manifest'.
09:51:18 2020 4720 Getting the 'assemblyIdentity' element.
09:51:18 2020 4720 Success.
09:51:18 2020 4720 Getting the 'name' attribute.
09:51:18 2020 4720 Success. The name is 'PerTrac.PowerLink, PublicKeyToken=1b72b137335e31c3'.
09:51:18 2020 4720 Getting the 'name' attribute.
09:51:18 2020 4720 Success. The class name is 'PerTrac.PowerLink.PowerLinkUserDefinedFunctions'.
09:51:18 2020 4720 Attempting to create a new instance of the XLL class.
09:51:18 2020 4720 An attempt was made to load a program with an incorrect format.
09:51:18 2020 4720 An attempt was made to load a program with an incorrect format.
09:51:18 2020 4720 Start - xlAddInManagerInfo12.
09:51:18 2020 4720 Creating a new instance of the XLL loader.
09:51:18 2020 4720 Success.
09:51:18 2020 4720 Getting the CLSID of the managed XLL class.
09:51:18 2020 4720 Success.
09:51:18 2020 4720 Loading the configuration from the system registry.
09:51:18 2020 4720 Getting the latest CLR version.
09:51:18 2020 4720 The latest CLR version is 'v4.0.30319'.
09:51:18 2020 4720 The configuration has been loaded successfully.
09:51:18 2020 4720 Runtime version: v2.0.50727.
09:51:18 2020 4720 Assembly name: PerTrac.PowerLink, Version=1.0.22.0, Culture=neutral, PublicKeyToken=1b72b137335e31c3.
09:51:18 2020 4720 Class name: PerTrac.PowerLink.PowerLinkUserDefinedFunctions.
09:51:18 2020 4720 Attempting to create a new instance of the managed XLL class: CLR - v2.0.50727
09:51:18 2020 4720 Getting the base directory for the domain.
09:51:18 2020 4720 Success. The directory is 'C:\TFS\dotNet Projects\Release\PowerLink\V1.0\PerTrac PowerLink\bin\Debug\'.
09:51:18 2020 4720 Openning adxloader.dll.manifest.
09:51:18 2020 4720 Success. The manifest is 'C:\TFS\dotNet Projects\Release\PowerLink\V1.0\PerTrac PowerLink\bin\Debug\adxloader.dll.manifest'.
09:51:18 2020 4720 Getting the 'assemblyIdentity' element.
09:51:18 2020 4720 Success.
09:51:18 2020 4720 Getting the 'name' attribute.
09:51:18 2020 4720 Success. The name is 'PerTrac.PowerLink, PublicKeyToken=1b72b137335e31c3'.
09:51:18 2020 4720 Getting the 'name' attribute.
09:51:18 2020 4720 Success. The class name is 'PerTrac.PowerLink.PowerLinkUserDefinedFunctions'.
09:51:18 2020 4720 Attempting to create a new instance of the XLL class.
09:51:18 2020 4720 An attempt was made to load a program with an incorrect format.
09:51:18 2020 4720 An attempt was made to load a program with an incorrect format.
Hope this helps.
- Matt - |
|
Posted 13 Jul, 2010 12:20:00
|
|
Top
|
|
Andrei Smolin
Add-in Express team
Posts: 18821
Joined: 2006-05-11
|
Hi Matt,
What platform is used in your project? AnyCPU? x86? What is the bitness of your Office 2010?
Andrei Smolin
Add-in Express Team Leader |
|
Posted 14 Jul, 2010 01:56:26
|
|
Top
|
|
Matt Comstock
Guest
|
Hi Andrei,
Thanks for your quick response.
All projects are built for x86, as we use the Jet driver for Access database usage, and it doesn't work when compiled for x64.
By "the bitness of Office 2010", do you mean x86/x64? I am developing/running on Vista Business x64, and my Office version is "Microsoft Office Professional Plus 2010", version 14.0.4763.1000.
Let me know if you need any additional information. Thanks.
- Matt - |
|
Posted 14 Jul, 2010 09:49:25
|
|
Top
|
|
Andrei Smolin
Add-in Express team
Posts: 18821
Joined: 2006-05-11
|
Hi Matt,
Matt Comstock wrote:
By "the bitness of Office 2010", do you mean x86/x64?
Yes. Please start Excel and choose File tab | Help. My Excel says "Version: 14.0.4760.1000 (32-bit)".
Andrei Smolin
Add-in Express Team Leader |
|
Posted 14 Jul, 2010 11:45:01
|
|
Top
|
|
Rafael Castañeda
Posts: 36
Joined: 2010-04-05
|
Hi all I have the same problem, my Excel is 2010 32 bits, on Windows 7 64 bits.
My project also has a ribon and some UDFs, the GUI works as it should, but the xll with all udfs is not loading, all my projects are for x86 as I also use Access database.
Exactly same problem
:D
Rafael |
|
Posted 14 Jul, 2010 13:39:10
|
|
Top
|
|
Matt Comstock
Guest
|
Hi Andrei,
Mine says the same version as yours, except 64-bit.
Rafael: Well at least you're getting your ribbon! I get nothing...
- Matt - |
|
Posted 14 Jul, 2010 16:00:10
|
|
Top
|
|
Andrei Smolin
Add-in Express team
Posts: 18821
Joined: 2006-05-11
|
Hi Matt,
Your add-in doesn't load because a 64-bit Office application cannot load a 32-bit add-in DLL. That is, you need to build it for x64.
Hi Rafael,
Rafael Castañeda wrote:
but the xll with all udfs is not loading
Any error messages? Any other symptoms?
Andrei Smolin
Add-in Express Team Leader |
|
Posted 15 Jul, 2010 01:07:51
|
|
Top
|
|
Matt Comstock
Guest
|
Hi Andrei,
Well, in retrospect, I guess I should have known that!
Thanks.
- Matt - |
|
Posted 15 Jul, 2010 09:40:48
|
|
Top
|
|