All geek questions in one place

Deploy Excel UDF

I have excel UDF that calls a web service. UDF code is an automation add code, which is a C # class library, and I created an installer for it. When I start the setup, in the list of additives toos → addins-> automation excins there is no excel, and the function is not apepar in the formula bar. I am using VS 2008 and Excel 2003.

Am I missing something? Do I have to determine the path that Excel should choose for the dll in order to point to the DLL generated from the udf code? Or are there security issues to take care of? The client computer has security levels set to full trust, but the addition does not appear in the list.

Did I miss something?

+3
source share
1 answer

This is because when you install an automation add-in, you need to create a custom CLSID {GUID} \ Programmable] entry in the registry, which when creating an automation add-in is usually processed by including the methods marked by ComRegisterFunctionAttribute and ComUnregisterFunctionAttribute in your class. These classes are then registered when RegAsm runs in your assembly.

Visual Studio ComRegisterFunctionAttribute ComUnregisterFunctionAttribute . , Project Setup RegAsm /regfile, REG , . .reg, , .msi . , RegAsm /regfile, .reg , (, , ComRegisterFunctionAttribute ComUnregisterFunctionAttribute).

CLSID {GUID}\Programmable , , .

, "CLSID {GUID}\Programmable" . , .

. , , ( , ) : COM- Excel, VB.NET, .

, !

Mike

+6

Source: https://habr.com/ru/post/1729559/

More articles:


All Articles