[AccessD] Amortization

Paula Wright paulawright at boddienoell.com
Fri Aug 15 11:46:36 CDT 2003


Question:  Would an Excel active-X work?  I guess the other option would be
to build the data into a table somehow.

Thanks for the info everyone.

Paula

-----Original Message-----
From: Mike and Doris Manning [mailto:mikedorism at ntelos.net] 
Sent: Friday, August 15, 2003 12:24 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Amortization


How will that help her Charles?

She can't use CreateObject or GetObject as part of her automation code
because it won't work on a computer that doesn't have Excel installed.

Short of creating an Access report that does what the Excel spreadsheet does,
what she is trying to do cannot be legally done if the user doesn't have
Excel installed.

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 Wortz, Charles
Sent: Friday, August 15, 2003 12:05 PM
To: Access Developers discussion and problem solving
Subject: RE: [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 _______________________________________________
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



More information about the AccessD mailing list