Update Excel data from an Outlook form

I hv a form that pulls data from an EXCEL WS into custom fields in OLXP.
Essentially, the form has 1 combo box that pulls values from 1 EXCEL
Column, 1 Textbox that will pull another value from the WS corresponding
to the item selected in the COMBO BOX. What I am trying to do is input a
changed value into this cell into the EXCEL WS with a Button on the
form.

I am using ADO to open the Excel worksheet and pull this data and
rs.update for changing the value. Everything works fine except the
update part. I get an ODBC EXCEL Error "Invalid String or Buffer
length".

Pl help to get over this problem
Tks
Nitin

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.732 / Virus Database: 486 - Release Date: 29-Jul-04

I'd suggest that you simplify the project by using a two column combo box.
The second column would be hidden and would contain the values that you want
to put in the text box. That way, you would only need to make one call to
the worksheet, the one that fills the combo box.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Nitin Shingote" <nitin@shingotex.com> wrote in message
news:002101c47f82$1828f570$0100a8c0@shex.org...
> I hv a form that pulls data from an EXCEL WS into custom fields in OLXP.
> Essentially, the form has 1 combo box that pulls values from 1 EXCEL
> Column, 1 Textbox that will pull another value from the WS corresponding
> to the item selected in the COMBO BOX. What I am trying to do is input a
> changed value into this cell into the EXCEL WS with a Button on the
> form.
>
> I am using ADO to open the Excel worksheet and pull this data and
> rs.update for changing the value. Everything works fine except the
> update part. I get an ODBC EXCEL Error "Invalid String or Buffer
> length".
>
> Pl help to get over this problem
> Tks
> Nitin
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.732 / Virus Database: 486 - Release Date: 29-Jul-04
>
>