[AccessD] Amortization

Paula,

This is the reason I suggested converting the Excel macros to Access VBA
modules so you do not need the Excel object library.  You will be using
the Access object libraries which you do have the right to distribute if
you have ODE.

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: Mike and Doris Manning [mailto:mikedorism at ntelos.net] 
Sent: Friday 2003 Aug 15 10:43
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Amortization

Office Developer only gives you the right to distribute the Access
run-time engine which is necessary for a user to run your Access program
if they don't have Access on their system.  This was done because users
had a choice to buy just Office or Office Pro (which included Access).

It does not give you the right to redistribute an Access database that
uses the Word or Excel object models to a user who does not have Word or
Excel installed on their system.  You do not have a legal right to
install or distribute the object libraries involved to a user who
doesn't have them.

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 11:04 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Amortization


Even if you have Office Developer - which of course you would if you
were going to create a run-time?

-----Original Message-----
From: Mike and Doris Manning [mailto:mikedorism at ntelos.net] 
Sent: Friday, August 15, 2003 11:03 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [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
-----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