[AccessD] Amortization

Doris,

Maybe I didn't make myself clear.  The conversion process is not part of
the deployment package, it is a one-time only step in the development
process.  This is only done on Paula's computer that has ODE, Access,
and Excel.

Presumably Paula has an Excel spreadsheet that does amortization.  She
needs to import and convert the Excel macros in that spreadsheet into
Access and make them an Access VBA module.  All references to Excel
objects will need to be converted to equivalent Access objects.  When
she has done all that, instead of an Excel spreadsheet where the user
enters the data to use in the calculation, she will have an Access form
where the user enters the data to be used.  Some of the functions used
in the Excel amortization spreadsheet may have exact equivalents in the
Access financial functions.  Some she may have to write code to perform
the same function since there is not equivalent in the Access financial
functions library.

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 11:24
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

-----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