VSTO and Excel Userdefined formulas

[sandhya]

Hi

Created VSTO addin in c# and how can we map to Excel's Userdefined function
in excel. Means
whenever i click on a buttom from VSTO Addin , it should refresh the excel
worksheet.
The userdefined function is written as an automation addin .

VSTO and the UDF should work together

[Cindy M.]

Hi Sandhya,

Post by sandhya
whenever i click on a buttom from VSTO Addin , it should refresh the excel
worksheet.

Have you tried using the Calculate method of the Worksheet and/or Range
object in your code, at the point where you want to force the recalculation?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)