Manipulating an Excel OLE object in Notes
Posted on 2003-11-17
I'm trying to create an applicatiaon in notes that gives a user the "excel" flexibilty but store the data in notes. I'm new to notes but have had some training. This is what I have done so far.
(1) I tried embedding an excel sheet in a form, looks great, I can double click to open it up, but when I exit the sheet (by definition) the data is not stored in the form.
(2) I have embedded the excel in a page and get a similiar problem in that I can only open the excel as read only.
(3) I have created a form with a rich text field and then created a document with that form imbedding an excel. The problem is how do I get at the document and have the abilty to open it up using excel within notes.
If I can get the excel stored in notes and have a way for the user to access it via excel, then I want to be able to take that embedded excel, run a script to take each row within the excel and create individual documents in the nsf.