Not sure if this question has already been discussed, I couldnt find an answer in Google newgroups, so your help will be greatly appreciated

An example: in Excel, under Tools-Add-Ins, select €˜Analysis Toolpack option. Now if you go under Insert-Function, youll see new functions from that add-in, such as MROUND function under function category €˜All

If you close Excel and launch it programmatically, the add-in seems to be loaded (checked) but the functions from it (such as MROUND) are missing. This happens both in 97 and 2000

To launch Excel I simply created a new VB project with a form and put this code

Private Sub Form_Load(
Dim oExcel As Excel.Applicatio
Set oExcel = CreateObject("Excel.Application"
oExcel.Workbooks.Ad
oExcel.Visible = Tru
End Su

Is this an Excel bug or is there something special that needs to be done to load the functions from the add-in

Thanks