[AccessD] Export To Excel - Formulas Possible?

Yes, you can dynamically add formulas to spreadsheets you create through
Access. You can also add worksheets as required.
Jim Hale

-----Original Message-----
From: Lawrence Mrazek [mailto:lmrazek at lcm-res.com]
Sent: Wednesday, November 16, 2005 9:29 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Export To Excel - Formulas Possible?


 Hi:

I'm developing specifications for a reporting app that pulls information
from a corporate database. While the print reports won't be a problem, the
client also requires an export to excel with the following functionality.

1. Single Worksheet with multiple tabs
2. Application calculates totals in Excel. (that is, if they make a change
in the data in Excel, it is reflected in the totals).  

Question. Can I automate the creation of the spreadsheet if I have to embed
formulas to calculate totals, percentages, etc.? Or do I need to first
create a template in Excel? I'd like to be able to do this from Access,
since they'll be adding group categories to the list and I don't want to
have to continually revise the excel file. 

Thanks.

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304


***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.