View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ralf Zimmermann Ralf Zimmermann is offline
external usenet poster
 
Posts: 1
Default Using UDF in COM Addin as formula in worksheet

I have written a COM addin in VB to store user defined data in
CustomDocumentProperties of a workbook. Now i want to insert these props in
a cell
like

Application.ActiveCell.FormulaR1C1 = "=GETPROPERTY(""" &
sPropertyName & """)"

It works if i define the GETPROPERTY function directly in a module of
workbook, but i want to define this function in the COM addin without
writting a wrapper XLA. (see MSDN KnowledgeBase article Q256624 - Howto: Use
a COM Add-In Function as an Excel Worksheet function)

Is this possible???

Thanks in advance.Ralf