Excel CumiPmt Function in A2k

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

Guest

I am trying to replace an Excel spreadsheet that contains the Cumipmt() function with an Access 2000 database. I have not been able to figure out how to get the calculation. The CumiPmt function uses the actuarial method & I've even looked for code that would simply calculate using the actuarial method & can't find any. I even try to open an Excel worksheet with the function on it, but as soon as I enter in the values the function either returns a VALUE or NAME error. Short of having to enter everything into Excel then exporting it to Access everytime I'm out of ideas.
 
You should be able to use excel functions from within Access. Something like
(untested):

dim objExcel as object, vResult as variant
set objExcel = createobject ("Excel.Application")
vResult = objExcel.BLAH (11, 22)
objExcel.quit
set objExcel = nothing

The example assumes that Excel has a function named BLAH with two numeric
parameters.

This is not very efficient - it starts & stops Excel each time - so you
should not put it in a loop etc.

HTH,
TC


laakins said:
I am trying to replace an Excel spreadsheet that contains the Cumipmt()
Click to expand...
function with an Access 2000 database. I have not been able to figure out
how to get the calculation. The CumiPmt function uses the actuarial method
& I've even looked for code that would simply calculate using the actuarial
method & can't find any. I even try to open an Excel worksheet with the
function on it, but as soon as I enter in the values the function either
returns a VALUE or NAME error. Short of having to enter everything into
Excel then exporting it to Access everytime I'm out of ideas.
 
Back
Top