K
kumar_8675
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
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