Wortz, Charles
CWortz at tea.state.tx.us
Fri Aug 15 09:42:57 CDT 2003
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