error message on custom form

  • Thread starter Thread starter dh
  • Start date Start date
D

dh

I have a custom Outlook form that has an excel object ("spreadsheet") that
works fine in Outlook 2000/Windows 2k. When we try to open a form in
Outlook 2003 on an XP machine, we get the following error message:
"Could not find the specified object Line no. 5"
viewing the code, line 5 is: Set XLSheet = oPage.Controls("Spreadsheet1")
and the other error message is:
" could not open some objects because they are not available on this
machine"
Is this a show stopper, or does it just require a reconfig of the newer
version of Office/Outlook
Thanks!
DH

PS all of the code from the form is as follows:
Dim XLSheet

Function Item_Open()
Set oPage = Item.GetInspector.ModifiedFormPages("Message")
Set XLSheet = oPage.Controls("Spreadsheet1")
XLSheet.HTMLData = Item.Body
Item.Subject = Item.Subject 'Dirty the form
End Function

Function Item_Write()
Item.Body = XLSheet.HTMLData
End Function
 
Interesting! I wonder if you need to install the Outlook 2000 version of the
spreadsheet control. That's pretty icky if it's the case. Have you checked
to see whether the Office 2003 version of the Office Web Components are
installed? They should be by default, but it might be worth trying to add
them to your control toolbox to check.
 
I looked to see if the Office Web components were installed and they were.
To load the Outlook 2000 version of the spreadsheet control, I looked at
customizing the toolbox and adding it to the toolbox but I didn't try to
modify the form (add a new object). Doing the above did not change the
error message. By the way, the objects on the form that are in question,
don't even load on the form, so if adding say the outlook 2003 version of it
would require a special version of the form that just runs on 2003 version
machines.. I also tried using the registry hack that you have on your
website (allowactiveXonoffforms) and that didn't help.
Anything else I am missing?
Thanks again!
DH
 
Back
Top