Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent Pls, how to convert an addin xlam file to xls worksheet in | Excel Discussion (Misc queries) | |||
Formula Evaluator Addin??? | Excel Discussion (Misc queries) | |||
How do I edit a worksheet that has been defined as an addin | Excel Discussion (Misc queries) | |||
AddIn | Excel Programming | |||
raw speed for excel worksheet functions? - xll -or com addin? | Excel Programming |