[AccessD] Export To Excel - Formulas Possible?

Paul Hartland (ISHARP) paul.hartland at isharp.co.uk
Wed Nov 16 09:42:14 CST 2005


Yes you can send formula to an Excel sheet, I have recently used this:

.Cells(intExcelRowArray(intSheet) + 3, 2) = "=SUM(B2:B" &
intExcelRowArray(intSheet) & ")"

With the 

"=SUM(B2:B" & intExcelRowArray(intSheet) & ")"

Being the actual formual that I need to sum column B row 2 to column B and
whatever the last row that I actually sent data to

Hope this helps

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek
Sent: 16 November 2005 15:29
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

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Wednesday, November 16, 2005 8:38 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Search with Ctrl+B freeze app

I'm looking too...and nothing happens...in Access...now in IE a window opens
to 'Manage Favorites'.

Any other clues?

Thanks,

Mark A. Matte


>From: "Gustav Brock" <Gustav at cactus.dk>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Search with Ctrl+B freeze app
>Date: Wed, 16 Nov 2005 15:11:59 +0100
>
>Hi Andy
>
>Focus on a textbox, that should do.
>But I recall faintly that you perhaps can shut this function off? No 
>popup-menus?
>
>/gustav
>
> >>> andy at minstersystems.co.uk 16-11-2005 13:38 >>>
>Where do you have to be for this to happen? I'm Ctrl-B'ing like mad and 
>nothing's happening.
>
>--
>Andy Lacey
>http://www.minstersystems.co.uk
>
>
>
>
>--------- Original Message --------
>From: "Access Developers discussion and problem solving"
><accessd at databaseadvisors.com>
>To: "accessd at databaseadvisors.com" <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Search with Ctrl+B freeze app
>Date: 16/11/05 12:48
>
>
>Hi Andy
>
>It pops the small native Access search form.
>
>/gustav
>
> >>> andy at minstersystems.co.uk 16-11-2005 12:34 >>>
>Sorry Gustav, but I've got to ask - what does Ctrl B do?
>
>
>--
>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



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