I have an VB6.0 automation add-in which has a set of functions that rea
data from an xml file and return the values. These functions are calle
from excel 2003 spreadsheet cells.

I have one problem in that when the spreadsheet launches, it does no
call the add-in functions and populate the data in the cells. I need t
click on the cells and do a tab change for the functions to be calle
and cells to be populated.

How can I force the add-in functions to be called on the start of th
spreadsheet so that it would populate the sheet with the new values.

Appreciate your help

--
kumar_867
-----------------------------------------------------------------------
kumar_8675's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27255