Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Running out of memory
Message
 
To
17/09/1999 17:32:18
Slawek Lehmann
Sparagowski & Associates
Toledo, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00266188
Message ID:
00266562
Views:
16
Slawek,
Have you tried adding
Release ExcelSheet
to your code after the
ExcelSheet.close
command?

HTH
Barbara

>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
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform