Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Loosing memory from excel object.
Message
De
19/03/1999 17:36:38
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Loosing memory from excel object.
Divers
Thread ID:
00200020
Message ID:
00200020
Vues:
49
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform