Viewing spreadsheets from Progress

[Emma]

I am creating an excel spreadsheet on the fly using data from a table.The first time i click the button to view the invoice, it appears perfectly. if i shut it down and then try to view the same invoice again, without leaving the program, the spreadsheet appears, but without the information from the tables. It is just blank. Any ideas as to why this is happening? If i leave the program and then reenter it, the invoice appears again.

TIA

Emma

 

[Emma]

Originally posted by Emma
I am creating an excel spreadsheet on the fly using data from a table.The first time i click the button to view the invoice, it appears perfectly. if i shut it down and then try to view the same invoice again, without leaving the program, the spreadsheet appears, but without the information from the tables. It is just blank. Any ideas as to why this is happening? If i leave the program and then reenter it, the invoice appears again.

TIA

Emma

i had an idea this is due to not releasing com-handles properly. this was confirmed, but i can't see why the code does not work. i have attached a file containing the code i am using to see if anyone can make a suggestion.

TIA.

Emma. :blue: