XLL Functions work for a moment, then stops working

Add-in Express™ Support Service
That's what is more important than anything else

XLL Functions work for a moment, then stops working
 
Rafael Castañeda




Posts: 36
Joined: 2010-04-05
Hi I have 36 udf?s and all have this same behavior, when I first load the project on excel everything seems to work fine all udf?s work, but after some time and after some updates on the sheet they stop working.

Any Ideas of what is going on ???

Tahnks In advance
Posted 21 Oct, 2010 12:07:50 Top
Eugene Astafiev


Guest


Hi Rafael,

What version and build number of Add-in Express do you use? Could you please show me the adxloader.log file which is typically located in the <My Documents>\Add-in Express folder? Could you please specify OS and Excel version?
Posted 21 Oct, 2010 12:13:55 Top
Rafael Castañeda




Posts: 36
Joined: 2010-04-05
Sorry for the delay I was out of town, I?m copying the log file I?m using Windows 7 and Excel 2011 my versi?n number and build is 6.2.3050 this happens after i upd ate certain number of excel cells, after that every cell that is updated gets the error.

Thanls in advance



Add-in Express Loader Log File: 10/26/2010 13:06:45
Startup directory: C:\Users\Rafael\Documents\Visual Studio 2008\Projects\Extractor_CAME\Extractor_CAME\bin\Release\
Loader version: 6.2.3050
------------------
13:06:45 228 7660 Start - xlAutoOpen.
13:06:45 228 7660 Creating a new instance of the XLL loader.
13:06:45 228 7660 Success.
13:06:45 228 7660 Getting the CLSID of the managed XLL class.
13:06:45 228 7660 Success.
13:06:45 228 7660 Loading the configuration from the system registry.
13:06:45 228 7660 Getting the latest CLR version.
13:06:45 228 7660 The latest CLR version is 'v4.0.30319'.
13:06:45 228 7660 The configuration has been loaded successfully.
13:06:45 228 7660 Runtime version: v2.0.50727.
13:06:45 228 7660 Assembly name: Extractor_CAME, Version=1.0.0.0, Culture=es-ES, PublicKeyToken=990d3ea46f626a37.
13:06:45 228 7660 Class name: Extractor_CAME.XLLModule.
13:06:45 228 7660 Attempting to create a new instance of the managed XLL class: CLR - v2.0.50727
13:06:45 228 7660 Loading CLR: v2.0.50727.
13:06:45 228 7660 Calling CLRCreateInstance method.
13:06:45 228 7660 Success.
13:06:45 228 7660 Calling GetRuntime method.
13:06:45 228 7660 Success.
13:06:45 228 7660 Calling GetInterface method.
13:06:45 228 7660 Calling GetInterface method for the CorRuntimeHost interface.
13:06:45 228 7660 Success.
13:06:45 228 7660 Starting CLR...
13:06:45 228 7660 Success.
13:06:45 228 7660 The CLR v2.0.50727 has been initialized successfully.
13:06:45 228 7660 Creating a new domain se tup.
13:06:45 228 7660 Success.
13:06:45 228 7660 Getting the add-in directory.
13:06:45 228 7660 Success. The directory is 'C:\Users\Rafael\Documents\Visual Studio 2008\Projects\Extractor_CAME\Extractor_CAME\bin\Release\'
13:06:45 228 7660 The configuration file is 'C:\Users\Rafael\Documents\Visual Studio 2008\Projects\Extractor_CAME\Extractor_CAME\bin\Release\app.config'
13:06:45 228 7660 The 'shadow copy' is enabled.
13:06:45 228 7660 Creating a new application domain.
13:06:45 228 7660 Success.
13:06:45 228 7660 Getting the base directory for the domain.
13:06:45 228 7660 Success. The directory is 'C:\Users\Rafael\Documents\Visual Studio 2008\Projects\Extractor_CAME\Extractor_CAME\bin\Release\'.
13:06:45 228 7660 Openning adxloader.dll.manifest.
13:06:45 228 7660 Success. The manifest is 'C:\Users\Rafael\Documents\Visual Studio 2008\Projects\Extractor_CAME\Extractor_CAME\bin\Release\adxloader.dll.manifest'.
13:06:45 228 7660 Getting the 'assemblyIdentity' element.
13:06:45 228 7660 Success.
13:06:45 228 7660 Getting the 'name' attribute.
13:06:45 228 7660 Success. The name is 'Extractor_CAME, PublicKeyToken=990d3ea46f626a37'.
13:06:45 228 7660 Getting the 'name' attribute.
13:06:45 228 7660 Success. The class name is 'Extractor_CAME.XLLModule'.
13:06:45 228 7660 Attempting to create a new instance of the XLL class.
13:06:46 228 7660 Success.
13:06:46 228 7660 Getting the dispid of the 'autoOpen' method.
13:06:46 228 7660 Success.
13:06:46 228 7660 Getting the dispid of the 'autoClose' method.
13:06:46 228 7660 Success.
13:06:46 228 7660 Getting the dispid of the 'autoAdd' method.
13:06:46 228 7660 Success.
13:06:46 228 7660 Getting the dispid of the 'autoRemove' method.
13:06:46 228 7660 Success.
13:06:46 228 7660 Getting the dispid of the 'autoFree' method.
13:06:46 228 7660 Success.
13:06:46 228 7660 Getting the dispid of the 'autoFree12' method.
13:06:46 228 7660 Success.
13:06:46 228 7660 Getting the dispid of the 'addInManagerInfo' method.
13:06:46 228 7660 Success.
13:06:46 228 7660 Getting the dispid of the 'addInManagerInfo12' method.
13:06:46 228 7660 Success.
13:06:46 228 7660 Getting the dispid of the 'Dispose' method.
13:06:46 228 7660 Success.
13:06:46 228 7660 Getting the dispid of the 'initialize2' method.
13:06:46 228 7660 Success.
13:06:46 228 7660 Invoking the 'initialize2' method.
13:06:46 228 7660 Success.
13:06:46 228 7660 The managed XLL class has been created successfully.
13:06:46 228 7660 Forwarding xlAutoOpen to the managed code.
13:06:46 228 7660 Success.
13:06:46 228 7660 Start.
13:06:46 228 7660 Reading the registry key 'HKEY_CLASSES_ROOT\CLSID\{8D84E1D5-5CDE-4DE9-8D5C-A6CCF597D8B8}'
13:06:46 228 7660 Success. The registry key 'HKEY_CLASSES_ROOT\CLSID\{8D84E1D5-5CDE-4DE9-8D5C-A6CCF597D8B8}' is closed.
13:06:46 228 7660 Converting the '{4BA250A6-8BCA-46A6-982A-F340081187C3}' CLSID from string.
13:06:46 228 7660 Success.
13:06:46 228 7660 Attempting to get the class object by the '{4BA250A6-8BCA-46A6-982A-F340081187C3}' CLSID.
13:06:46 228 7660 Success.
13:06:46 228 7660 Creating a new instance of the add-in loader.
13:06:46 228 7660 Success.
13:06:46 228 7660 Loading the configuration from the system registry.
13:06:46 228 7660 Getting the latest CLR version.
13:06:46 228 7660 The latest CLR version is 'v4.0.30319'.
13:06:46 228 7660 The configuration has been loaded successfully.
13:06:46 228 7660 Runtime version: v2.0.50727.
13:06:46 228 7660 Assembly name: Extractor_CAME, PublicKeyToken=990D3EA46F626A37.
13:06:46 228 7660 Class name: Extractor_CAME.AddinModule.
13:06:46 228 7660 Attempting to create a new instance of the managed add-in class: CLR - v2.0.50727
13:06:47 228 7660 Unwrapping the managed class.
13:06:47 228 7660 Success.
13:06:47 228 7660 Querying the add-in extensibility.
13:06:47 228 7660 Querying the custom task panes.
13:06:47 228 7660 Querying the ribbon extensibility.
13:06:47 228 7660 Success.
13:06:47 228 7660 Querying the form regions.
13:06:47 228 7660 Success.
13:06:47 228 7660 Getting the dispid of the 'Dispose' method.
13:06:47 228 7660 Success.
13:06:47 228 7660 The managed add-in class has been created successfully.
13:07:58 228 7660 Start - xlAutoClose.
13:07:58 228 7660 Forwarding xlAutoClose to the managed code.
13:07:58 228 7660 Success.
Posted 26 Oct, 2010 13:22:37 Top
Rafael Castañeda




Posts: 36
Joined: 2010-04-05
I have tested my project on Windows Xp and Excel 2003 and i get the same results
Posted 26 Oct, 2010 14:01:00 Top
Andrei Smolin


Add-in Express team


Posts: 18823
Joined: 2006-05-11
Hi Rafael,

We've never got such reports. I'd like that you check if you catch some exceptions in your code. Anyway, we will be unable to help you with the information that we currently have. May be you could provide some extra info? It would be perfect to have a reproducible case with a new add-in.


Andrei Smolin
Add-in Express Team Leader
Posted 27 Oct, 2010 11:43:51 Top
Rafael Castañeda




Posts: 36
Joined: 2010-04-05
Thank for the info, Currently I?m on the profesional version I would like to upgrade so you can review our code how do I upgrade and how much thanks in advance.


Rafael
Posted 29 Oct, 2010 11:06:17 Top
Svetlana Cheusheva


Add-in Express team


Posts: 244
Joined: 2005-02-02
Hi Rafael,

You can upgrade to the Premium package for the price difference, i.e. for USD 500. I can send the direct order link to the e-mail address specified in your profile. Will that do? Alternatively, you can write to me to the sales e-mail address, please see readme.txt for details. As you understand, I cannot just publish the link here, for obvious reasons :)
Posted 29 Oct, 2010 12:45:26 Top
Rafael Castañeda




Posts: 36
Joined: 2010-04-05
yes please send the link so i can make payment thanks in advance
Posted 29 Oct, 2010 13:14:46 Top
Svetlana Cheusheva


Add-in Express team


Posts: 244
Joined: 2005-02-02
Rafael,

Done, please check your inbox. Have a wonderful weekend!
Posted 29 Oct, 2010 13:25:10 Top
Rafael Castañeda




Posts: 36
Joined: 2010-04-05
Andrei I have upgraded to Premium so you can review my code, what is the steps so you can have a look at it??
Posted 29 Oct, 2010 14:35:36 Top