Problem using analysis toolpack when automating EXCEL

[Guest]

Hi,

I am automating EXCEL from vb.net. I am using the following command to run a
module function in the XL spreadsheet:

pappXL.Run("ImportFromCPMonitoring")

This works fine. The problem occurs when I try to use the EDATE function in
a formula - it just gives me "!NAME" even though I can see the the boxes
checked for the analysis toolpack and the VBA version. Does anyone know how
to solve this problem I am at my wits end.

 

[Tom Ogilvy]

See answer to your first posting of this question.