I created a automation plugin in VB 6.0 which basically has functions t
read data from an xml file. These functions are called from Excel 200
spreadsheet cells.

The one problem that I am having is that when I launch the Excel, thes
functions are not getting called. They are getting called only when
click on the cell of the worksheet. How can I force it to call an
populate all the cell values on launch of the spreadsheet.

I tried doing the following but of no help.
I would appreciate your expert advice in this regard.
undefined
--------------------------------------------------------------------------
Sub LoadXLwithAddins()
Dim xl As Object
Dim ai As Object

Set xl = CreateObject("Excel.Application")

For Each ai In Application.AddIns
If ai.Installed Then
xl.Workbooks.Open(ai.FullName).RunAutoMacros 1
End If
Next

xl.Visible = True
Set xl = Nothing
End Sub
------------------------------------------------

--
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=27242