[AccessD] Export To Excel - Formulas Possible?

The basic way to plug a formula into a spreadsheet is along the lines of
appExcel.range("f63:j63").Formula = "=k63"
Access won't "remember" but there are various ways you can figure it out.
How are you populating your spreadsheet? cell by cell? one big copyrecset?
Tell me a bit more and I may be able to tell you the best way to set your
totals.
Jim Hale

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


Thanks Jim (and Paul): 

I've run through a couple of samples and have successfully exported a
recordset, created a new sheet, and it looks like I should be able to do
this ... My main concern is the embedding of the formulas in the rows ... Is
it possible as I export the recordset to create a calculated column ... 

EX:	Column1	Column2	Column3 (calculated Column1 + Column2)
Oct	2		5		7
Nov	4		8		12
Total	6		13		19		

Basically, can the Access application "remember" which cells it wrote to, so
I can create out a totals row? Just trying to figure this out before
committing to the project. 

Thanks!				

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

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Wednesday, November 16, 2005 4:26 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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.
--
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

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