I am trying to work with an embedded excel spreadsheet and I am having a lot of problems.
First, when a user inputs data into the spreadsheet then saves and closes, those changes are not visible to anyone else who opens the document, unless they first open the excel spreadsheet. The changes remain visible after the spreadsheet is closed again. I tried to resolve this by "activating" the embedded object. I tried using the following code with I copied straight out of the help file which said it would activate the first embedded object (if any) in a document. However, when I try to run it, I get the error "Object variable not set."
Dim workspace As New NotesUIWorkspace
Dim uidoc As NotesUIDocument
Dim doc As NotesDocument
Dim item As Variant
Set uidoc = workspace.CurrentDocument
Set doc = uidoc.Document
Set item = doc.GetFirstItem("Body")
If item.EmbeddedObjects(0) Is Nothing Then
Messagebox "No embedded object in document"
If item.EmbeddedObjects(0).Type <> EMBED_OBJECT Then
Messagebox "Object not an embedded object"
Once this issue is resolved, I would like to be able to search the data contained in all of the excel spreadsheets contained in all of the documents. Any ideas on how to do this?