Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel volatil functions questions
Hi, If, for example, I have a function that is used in a report template and that needs to do some processing on the date. processDate(A1) where A1 contains the NOW() excel function. I have to questions : - I want the result of processDate() to be automatically recalculate when the user press F9, is volatil the good way to do? - When Excel refresh its data, will it refresh the NOW() cell before the processDate cell because if not, the result of processDate could be wrong? Thanks Nic -- nicgendron ------------------------------------------------------------------------ nicgendron's Profile: http://www.excelforum.com/member.php...o&userid=25151 View this thread: http://www.excelforum.com/showthread...hreadid=396201 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel volatil functions questions
Ok, but what should I do if I'm in the following situation : I want to make a excel model file to generate report each day. The report sheet uses my add-in and call the following function "GetCurrVall" At implementation level, this function uses a library to access server and get some value. In the report sheet, there is a lot of those calls. My problem is : When somebody opens the model to generate the report, he should refres all the cells. If I don't put the volatile attribute in the function the user has to manually refresh the cells that use "GetCurrVall". B putting the volatile attribute, he just has to press F9 and that' done. My question is : Is there another way to easyly refresh all the data given by my add-i ? Ni -- nicgendro ----------------------------------------------------------------------- nicgendron's Profile: http://www.excelforum.com/member.php...fo&userid=2515 View this thread: http://www.excelforum.com/showthread.php?threadid=39620 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Questions about functions | Excel Discussion (Misc queries) | |||
Several function questions (nested functions) | Excel Worksheet Functions | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
Array Functions - Two Questions | Excel Worksheet Functions | |||
Making progress with array functions, another two questions | Excel Programming |