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.