>I am trying to populate some Lotus 123 spreadsheets from Fox data. I have the following line in my code: oMyObject = getobject("Template.123"). I then populate it and do oMyObject.filesaveas("Newfile.123"). I then RELEASE oMyObject. Next I get more data for a new spreadsheet and use oMyObject = getobject("Template.123") again. This is where I get the above error message.
>
>The reason that I am using "getobject" multiple times is because the template contains the data from the previous go around and if the next one has less data the old data is added. I had a loop that would go through the cells and set them to " ", which did what I need to do but it was sooo sssllllooooowwww.
>
>Does anyone have any ideas on how to eliminate the error or empty the template between each data set.
>
>TIA,
>
>Gerald Brown
>Lockheed Martin a Contractor to EPA
>brown.gerald@epa.gov
Gerald,
I think this is happening because you've released the reference. I'm working with Lotus 1-2-3 97, and while I don't get the same OLE error after releasing and then attempting to retrieve using GETOBJECT(), I do get an OLE error. If you can eliminate that, your problem may disappear.
George
Ubi caritas et amor, deus ibi est