Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Running out of memory
Message
From
17/09/1999 17:32:18
Slawek Lehmann
Sparagowski & Associates
Toledo, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Running out of memory
Miscellaneous
Thread ID:
00266188
Message ID:
00266188
Views:
55
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
Map
View

Click here to load this message in the networking platform