[AccessD] Amortization

Paula,

If they don't have Excel installed, then you can copy the Excel macros
into Access and convert them to a module that you will run instead.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Paula Wright [mailto:paulawright at boddienoell.com] 
Sent: Friday 2003 Aug 15 09:30
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Amortization

You can do this without Excel being installed on the PC?

Paula

-----Original Message-----
From: Michael R Mattys [mailto:michael.mattys at adelphia.net] 
Sent: Friday, August 15, 2003 8:26 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Amortization


Hi Paula,

Short of this "template", is it possible
for you to use Excel from Access like this:

Function XLAMRT( [Args] )
    Dim obj As Excel.Application
    Set obj = CreateObject("Excel.Application")
    With obj
    .    WorksheetFunction.IPmt [Args]
    End With
    Set obj = Nothing
End Function

Michael R. Mattys
www.mattysconsulting.com


----- Original Message -----
From: "Paula Wright" <paulawright at boddienoell.com>
To: <accessd at databaseadvisors.com>
Sent: Friday, August 15, 2003 7:54 AM
Subject: [AccessD] Amortization


I know that Excel provides an amortization template.  However, I am
writing a program in Access that will be converted to run-time and I'm
wondering what is the best way to allow the client to run an
amortization.  Can an Excel spreadsheet be included in an Access
run-time program?

Paula Wright
Programmer/Analyst
paulawright at boddienoell.com
(252)937-2800 ext.1355