Excel's Analysis ToolPak: Cannot get to .AccrIntM, but can get to.Days360

  • Thread starter Thread starter PeteCresswell
  • Start date Start date
P

PeteCresswell

After setting up an instance of Excel, I am trying to
invoke .WorksheetFunction.AccrIntM().

I *think* I've got Analysis ToolPak installed, but my results seem to
contradict that.

OTOH, I'm assuming that .Days360 are in the same ToolPak and I am able
to see .Days360.

Bad assumption?

Here's what I see when I try to find AccrIntM(): http://tinyurl.com/dxgofn

Here's what makes me think that I've got the ToolPak installed
(Days360 appears):
http://tinyurl.com/dnez5z
 
Here's what makes me think that I've got the ToolPak installed
(Days360 appears):http://tinyurl.com/dnez5z
Click to expand...

Ok... bad assumption. Days360 is not part of the ToolPak.

When I work the list of functions that are installed (http://
support.microsoft.com/default.aspx?scid=kb;en-us;121730), none of them
show up.

So it seems like it'd down to what Yours Truly is doing that's dumb
when trying to make Analysis ToolPak available on-the-fly in an
instance of Excel created in MS Access VBA.
 
So it seems like it'd down to what Yours Truly is doing that's dumb
when trying to make Analysis ToolPak available on-the-fly in an
instance of Excel created in MS Access VBA.
Click to expand...

This seems tb one my longer self-conversations.

Anyhow, the issue seems tb semantics.

AccrInt does not exist for this:
myResult = gExcelApp.WorksheetFunction.AccrIntM(myPaymentDateLast,
mySettlementDate, myCouponRate, myParAmount, myBasis)

But this does the job:
gExcelApp.Run("AccrIntM", myPaymentDateLast, mySettlementDate,
myCouponRate, myParAmount, myBasis)
 
Back
Top