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

[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

 

[PeteCresswell]

Here's what makes me think...

Oops. I had the links reversed.

 

[PeteCresswell]

Here's what makes me think that I've got the ToolPak installed

(Days360 appears):http://tinyurl.com/dnez5z

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.

 

[PeteCresswell]

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.

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)