Excel Problem

[Chris Kelleher]

I've created a program that creates a workbook and then populates data onto
two sheets of the workbook. Thought everything was fine and then I noticed
that if you run the program for a larger date range everything appears fine
but when you close Excel it still shows up in the programs listed under
CTRL-ALT-DEL. Other programs start going into "Not responding" mode.

I just went over the proper way to release the com-handles (between sheets
to avoid the "Illegal Operation" error message) so I don't think it's that.
Why the difference between a small amount of data (250 lines) vs. a large
amount of data (1100 lines)?

Win 98/Progress 8.2C/Excel 97
Thanks,
David Hopper
Lowen Corporation

 

[Chris Kelleher]

Something's crapping out on the Progress side and not releasing your friend
excel.application. Try putting a msg view-as alert-box just before and
after all the releases at the end to be sure that they are released
properly. Also remember that if you assign a com-handle var to
excelapp.worksheet(1) then you have to release him, too!


PK