Deploying the COM Interop UDF for a SharePoint Client Excel workbook
-
I have created a COM Interop managed UDF in the sharepoint server and deployed it as an add-in for the Excel workbook.The excel workbook is placed in a trusted file location and the UDF is registered as a trusted UDF with sharepoint.I have followed the http://blogs.msdn.com/cumgranosalis/archive/2006/08/03/ServerClientUDFsCompat1.aspx to create the UDF to support COM Interop and make it usable by the Excel as an Add-in. When i open the sharepoint site from a different machine (not a sharepoint server machine),and open the excel workbook in edit mode , method calls in excel displays a #NAME error.This is because the add-in does not exist on the client machine. Is it possible that i download or register the dll (UDF) when the excel is opened on the client machine?(similar to the situation where ActiveX objects are asked for download when we open a browser) Can anybody help me with any alternate solutions for this problem? Priya G