Problem using analysis toolpack when automating EXCEL
 

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.

Problem using analysis toolpack when automating EXCEL
 

See answer to your first posting of this question.

--
Regards,
Tom Ogilvy

"Dave Gruzewski" wrote in message
...
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.