Re: Excel WS does not retain values

You have to provide code behind the form to store the data and reload it into the worksheet control. See http://www.slipstick.com/dev/spreadsheetcontrol.htm
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm


"Nitin" <shingote@yahoo.com> wrote in message news:%23J6M9EhQDHA.3192@tk2msftngp13.phx.gbl...
> I hv a post form with customs fields on the 1st page. On the 2nd page, I hv
> an Excel Worksheet inserted as an object which I hv pre-formatted. The form
> is published to a POST folder.
>
> When I try to post a new entry using this form, field values on the first
> page are retained but the values I enter in the Excel Worksheet are lost and
> it shows only the preformatted worksheet.
>
> What do I need to do??
>
> Tks
>
>

Thanks, Sue - you r wonderful!

"Sue Mosher [MVP]" <suemvp@slipstick.com> wrote in message
news:ejVTBriQDHA.3700@tk2msftngp13.phx.gbl...
You have to provide code behind the form to store the data and reload it
into the worksheet control. See
http://www.slipstick.com/dev/spreadsheetcontrol.htm
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm


"Nitin" <shingote@yahoo.com> wrote in message
news:%23J6M9EhQDHA.3192@tk2msftngp13.phx.gbl...
> I hv a post form with customs fields on the 1st page. On the 2nd page, I
hv
> an Excel Worksheet inserted as an object which I hv pre-formatted. The
form
> is published to a POST folder.
>
> When I try to post a new entry using this form, field values on the first
> page are retained but the values I enter in the Excel Worksheet are lost
and
> it shows only the preformatted worksheet.
>
> What do I need to do??
>
> Tks
>
>