Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

VSTO and Excel Userdefined formulas

2 views
Skip to first unread message

sandhya

unread,
Aug 3, 2009, 2:52:01 AM8/3/09
to
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.

unread,
Aug 3, 2009, 7:07:07 AM8/3/09
to
Hi 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 :-)

0 new messages