When you automate excel, addins are not loaded - you need to load the
analysis toolpak yourself with your code.

--
Regards,
Tom Ogilvy

"Dave Gruzewski" wrote in message
...
Hi,

I am trying to automate and excel workbook from vb.net code
calling a module with this command(vb.net):

pappXL.Run("ImportFromCPMonitoring")

This works totally fine - but when it gets to anywhere in the spreadsheet
where EDATE is used in a formula - it fails. I am totally at my wits end
with
this. Is there any reason why this function would not work? - I stop the
code
while it is running and check the tools-addins and both analysis packs are
checked.

Please help

Thanks