My application reads a database and creates a new spreadsheet per record.
In a loop an Excel Template is loaded, data from the database filled into predefined locations of the Template and then it is saved under a different name. This gives an excellent view on the data including calculations within the spreadsheet. Your component is suited perfectly for this application.
Everything works out fine in the developement environment. However when installed on a different machine the timing got wrong. After fiddling around several hours I finally found that the loading (spreadsheet1.open(Filename)) takes to long. The program writes data to "whereever" before the spreadsheet is completely loaded. As a result the saved spreadsheet either only has the Template or even garbage (some data without template data). There is no indication of an error from the components!
The only workaround I found is to insert a sleep timer (system.thread.sleep(1000)) after the load statement. Application.Doevents was not good enough. When given enough time to load the spreadsheet the program works perfect - Template including all data is saved as expected.
I would wish you included either a "wait" option in the .OPEN statement or at least mention somewhere that the loading is not synchronous (= program needs to make sure file is loaded before manipulating the spreadsheet).
Best regards
Gerhard Nanninga
