RE: Update Excel data from an Outlook form

Thanks, Sue

But I need to see the value in the 2nd column to decide if it needs to
be updated.
Any ideas?

Nitin

-----Original Message-----
From: microsoft.public.outlook.program_vba@shingotex.com
[mailto:microsoft.public.outlook.program_vba@shingotex.com] On Behalf Of
Sue Mosher [MVP-Outlook]
Sent: Wed - August 11, 2004 5:18 PM
To: microsoft.public.outlook.program_vba@shingotex.com
Subject: Re: Update Excel data from an Outlook form


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



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


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

Isn't that what you'd use the text box for -- letting the user update the
value? In other words, from what you describe, I think it would work like
this:

1) User selects value from combo box
2) Code puts value from corresponding hidden 2nd column in text box
3) User updates value in text box
4) User clicks button that updates Excel worksheet and updates hidden value
in combo list.

--
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:002301c47f9d$8b709220$0100a8c0@shex.org...
> Thanks, Sue
>
> But I need to see the value in the 2nd column to decide if it needs to
> be updated.
> Any ideas?
>
> Nitin
>
> -----Original Message-----
> From: microsoft.public.outlook.program_vba@shingotex.com
> [mailto:microsoft.public.outlook.program_vba@shingotex.com] On Behalf Of
> Sue Mosher [MVP-Outlook]
> Sent: Wed - August 11, 2004 5:18 PM
> To: microsoft.public.outlook.program_vba@shingotex.com
> Subject: Re: Update Excel data from an Outlook form
>
>
> 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.

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