Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Loosing memory from excel object.
Message
From
19/03/1999 17:36:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Loosing memory from excel object.
Miscellaneous
Thread ID:
00200020
Message ID:
00200020
Views:
50
I´ve found that accessing the pagesetup object of an excel application uses some memory wich is not released after closing the excel object.

Try this:
1. Check the amount of memory available (setup - control Panel - system - performance)
2. run the following code

MyExcel = CreateObject("Excel.Application")
MyExcel.WorkBooks.Add()
MyExcel.ActiveSheet.PageSetup.CenterHeader = "MY HEADER "
MyExcel.ActiveWorkBook.Close(.F.)

3. Check the available memory again (it´s decreased in about 2 - 4%)
4. Run the code again except for the 3rd line
3. Check the available memory again (it´s NOT decreased from last check)

How could I put a header on my excel object programmatically without loosing memory?

Thanks for any help.
There´s a better life... Just it´s more expensive!
Cristóbal Manrique M.
Next
Reply
Map
View

Click here to load this message in the networking platform