spreadsheet object imbeded in a custom form, data not coming with sent form.

[dh]

I have inserted an Excel table in a Custom Outlook form. When I run the
form, and fill in data in the spreadsheet, then send it, the data is erased
and I have a blank spreadsheet,
Any ideas?
Thanks!
DH

 

[Sue Mosher [MVP-Outlook]]

You must add code to save the data somewhere and then repopulate the
control. See http://www.outlookcode.com/d/spreadsheetcontrol.htm

 

[dh]

Thanks Sue!
I will give it a try!
DH

You must add code to save the data somewhere and then repopulate the
control. See http://www.outlookcode.com/d/spreadsheetcontrol.htm

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[dh]

The data is being saved. I need to know if there is a way to retain the
formating of the cells in the spreadsheet
I used you code to save the infomation in the cells. I have some cells set
at a specific length and height but when you run the form, the cells are of
a standard height and length. anyway around this?
Thanks!
DH

 

[Sue Mosher [MVP-Outlook]]

You'd have to devise your own scheme for saving the formatting information
and then include code to set those formats when the form loads.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[dh]

Thanks Sue!!
DH

You'd have to devise your own scheme for saving the formatting information
and then include code to set those formats when the form loads.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers