May be Automation AddIn loading problem!!
 

Hi,

We have a bunch of Excel sheets with data being filled in by code in VB
modules. To improve performance we want to convert the code in a Automation
DLL and delete the old module code. We do not want to touch any of the cell
formulas and the idea was, as the function name and signature in the DLL is
same as was in the modules, Excel should now just read the function code
from the DLL. But the Excel sheets data is not getting calculated giving
#NAME? everywhere. However putting fully qualified path
AutomationAddin.Connect.func(arg1) works. It is impossible to add that prefix
in thousands of formulas in all my worksheets so that's not a solution.
Function binding sequence order in Excel is Excel built-in function - VBA
Function -.XLA Regular Addin -Automation AddIn functions. But in my case
the function used is only avaialable in the DLL. One observation I had is
that when I open Excel and load the Automation AddIn the functions in the DLL
are seen in the Insert-Function section when we choose the Automation AddIn,
but when I launch Excel from my application, the AddIn check box in Tools
-Load is cheked, but the functions do not appear in the function section.
This tells me that on launching from my application the AddIn did not load
properly. FYI my sheets are protected.

Question :

a) Is there any way I can make my sheets get the data without changing any
code in them while using the Automation AddIn DLL.
b) For Automation AddIn once we load it we should have the function right?
Do not need to put it in any XAStart directory.
c) Also in another article here somebody mentioned that if the excel
shortcut has some command line switch excel does not load the AddIn. Could
that be a problem.
d) Does anybody know if I will save loading time in this method. I have a
lot of function call?

Can anybody help me with this. I had an earlier post on this but did not get
a solution. So I am reposting again the problem.

Thanks in advance
Abhijit