Update Excel data from an Outlook form

  • Thread starter Thread starter Nitin Shingote
  • Start date Start date
N

Nitin Shingote

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
 
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.
 
Back
Top