[AccessD] (OT) Excel - adding cell values

Oleg,

Then you are missing a needed reference to the Excel libraries.

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: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] 
Sent: Tuesday 2003 May 27 11:31
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] (OT) Excel - adding cell values

It was a first thing i tried. Gives me an error message "sub or function
not defined"


> You can try C = SUM("C13:C18")
>
> 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 
> Oleg_123 at xuppa.com
> Sent: Tuesday, May 27, 2003 10:12 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] (OT) Excel - adding cell values
>
>
> He group,
> does anyone know if I can use SUM in the case below ? I can't seem to 
> find it. Thanks
>
> C = Range("C13").Value + Range("C14").Value + Range("C15").Value + 
> Range("C16").Value + Range("C17").Value + Range("C18").Value