Problem using analysis toolpack when automating EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top