View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PeteCresswell[_2_] PeteCresswell[_2_] is offline
external usenet poster
 
Posts: 56
Default AccrIntM: "Object doesn't support...."

FWIW, it came down to this:

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

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