[AccessD] Access automation of Excel Column Summing After Cop yFromRecordset

Jim,

I'm getting object doesn't support this property or method runtime 438.
It's probably my built string. I will look at over the weekend.

Thanks,

Jim


> If you know how many rows the rs has and what row you start at you can
> build
> the the sum string, ie beginning row+record count+1 is where to paste the
> sum function
> Jim Hale
>
> -----Original Message-----
> From: Jim Moss [mailto:jim.moss at jlmoss.net]
> Sent: Friday, March 31, 2006 5:16 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access automation of Excel Column Summing After
> Cop yFromRecordset
>
>
> I guess that I don't know enough about the Range object. I'm using
> something like:
>
> With objSht
>      .range(.Cells(2, 1), .Cells(intMaxRow, _
>      intMaxCol)).CopyFromRecordset rs1
> End With
>
> because my recordsets always have different row counts. Normally when I
> need a total I just loop through the rs.
>
> Thanks,
>
> Jim
>
>> try something like
>> .Range("f63").Formula = "=sum(f1:f62)"
>> Jim Hale
>>
>> -----Original Message-----
>> From: Jim Moss [mailto:jim.moss at jlmoss.net]
>> Sent: Friday, March 31, 2006 4:42 PM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] Access automation of Excel Column Summing After
>> CopyFromRecordset
>>
>>
>> How do I programatically insert a SUM into the row following a
>> CopyFromRecordset? All that I seen to get is the text of SUM.
>>
>> Thanks,
>>
>> Jim
>>
>> --
>> 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.
>> --
>> 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.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>