[AccessD] Amortization

Please note that this WILL NOT work if the end-user doesn't have Excel.  You
CANNOT LEGALLY DISTRIBUTE the Excel Object Model even if you include it in
your Access run-time.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paula Wright
Sent: Friday, August 15, 2003 10:51 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Amortization


I will try this.  You don't happen to know of any examples anywhere, do you?

Thanks,
Paula

-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: Friday, August 15, 2003 10:43 AM
To: Access Developers discussion and problem solving
Subject: RE: [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 _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com