[AccessD] Amortization

No, Excel must be installed on the PC in order for this to work because you
do not have distribution rights for the Excel object model.

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:30 AM
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

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