HighTechTalks DotNet Forums  

VSTO and Excel Userdefined formulas

Visual Studio.net (Tools Office) microsoft.public.vsnet.vstools.office


Discuss VSTO and Excel Userdefined formulas in the Visual Studio.net (Tools Office) forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
sandhya
 
Posts: n/a

Default VSTO and Excel Userdefined formulas - 08-03-2009 , 01:52 AM






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

Reply With Quote
  #2  
Old   
Cindy M.
 
Posts: n/a

Default Re: VSTO and Excel Userdefined formulas - 08-03-2009 , 06:07 AM






Hi Sandhya,

Quote:
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 :-)

Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.