On Wed, 5 Jan 2005 08:25:35 -0500, "Tom Ogilvy"
wrote:

I don't know your specific situation, but when you open the workbook through
Automation, addins are not loaded. It is unclear when you manually edit the
cell, but if you have previously closed excel in your application and then
reopened it manually (at which time the addin would be loaded), then editing
it would indeed clear up the problem.

You could try opening the analysis toolpak like a regular workbook in your
COM app before you perform this operation.


Tom

Thanks Tom, that was the problem. I've added the following line

excelApp.AddIns.Item['Analysis ToolPak - VBA'].Installed:=True;

and the procedure is working fine now.

This group is absolutely amazing - an answer within a few hours!

Nirmal