If you take the sample program ExcelAp1 provided with PB and get it to loop by placing a label at the start of the function (after the DIM statements), and a GOTO label immediately before the END FUNCTION, it works the first time round but not the second: SET oExcelApp = NEW ExcelApplication IN sProgID_Excel returns PB error 99: "A run-time error occurred involving an object".
All the interfaces have been set to NOTHING at the end of the first run through. Something else obviously needs closing, resetting or initialising, but what?
Doing the same thing to the sample Word program, oWord.bas, works fine with Word starting up correctly each time.
Many thanks for any insight.
All the interfaces have been set to NOTHING at the end of the first run through. Something else obviously needs closing, resetting or initialising, but what?
Doing the same thing to the sample Word program, oWord.bas, works fine with Word starting up correctly each time.
Many thanks for any insight.
Comment