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