General information
Title:
Running out of memory
In my FoxPro programs I write reports into Excel. They run OK but when I have run and printed a few of them (around 8 - depending of the size of the report), the computer runs out of memory and freezes up. It looks like the objects are not released from the memory.
The system we use here is Windows'95 and we have Visual FoxPro 5.0
In the code I first get the excel object from my local drive:
excelsheet = getobject("c:\template00.xls")
Then I format the sheet and wite data into it.
I end the program with printing the sheet and closing it. I do not save the sheet:
excelsheet.application.displayalerts = .f.
excelsheet.windows("template00.xls").visible = .t.
excelsheet.printout
excelsheet.close
In my general program I finally quit the excel application when I am done writing all the reports.
I thought that closing particular excel objects (excelsheet.close) and then quiting the Excel application (excelsheet.application.quit) is sufficient to release the objects from the memory. Yet the computer still freezes after a few reports and displays "Out of memory" message.
Does somebody know why and what I can do to prevent this?
Thanks -- Slawek
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only