excel control doesn't do anything

[jo]

I am trying my second post on this matter. I am hoping that someone could
point me in the right direction.
I am desperately trying to get an excel control to function. I am running
officexp and the control doesn't save anything.
I have been looking at the www.lipstick website, which is the same code, the
outlook generates but for some odd reason the control doesn't save anything.

Help would be greatly appreciated.

Thanks

 

[Sue Mosher [MVP]]

You mean the spreadsheet control? Is the form published? Code does not run on unpublished forms in most cases.
--
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

 

[jo]

Sue,

Thanks for your reply. I did published the form into my
Personal Forms Library. No go. I am really stuck on the
part where the form should ask you to save the data.

Should I publish the form somewhere else?

Thanks again.

-----Original Message-----
You mean the spreadsheet control? Is the form published?

Code does not run on unpublished forms in most cases.

 

[Sue Mosher [MVP]]

I am really stuck on the

part where the form should ask you to save the data.

Sorry, but I don't know what you mean by that.

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

 

[jo]

Your code says that letting
item.subject = item.subject I should get the prompt
to "save changes" when I close the form. It doesn't.

Thanks much.