Problem embedding an object

HCL Domino Domino Forum
1

Hello

i want to embed an excel sheet in lotus notes so that the when the user opens the document he can directly see the excel sheets contents pasted on the document.

Please help

Regards

D S N

2

Subject: Problem embedding an object

Hello D,Try the following code in a form Post open and create a rich tex field in the form with the name Body.

Sub Postopen(Source As Notesuidocument)

Source.EditMode = True

Call Source.GoToField("Body")

If source.IsNewDoc Then

	Set Excel = Source.CreateObject("Excel", "OWC10.SpreadSheet.10")

Else

	Set Excel = Source.GetObject ("Excel")

End If

End Sub

It uses Office web components to embed the excel object in Excel sheet.

Please let us know if you get it working.

Regards,

Munish