Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Loosing memory from excel object.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00200020
Message ID:
00200127
Vues:
10
Jeff: Releasing MyExcel gave me back my mem, but only when I try the lines in the command window, but when I run that from within a program, mem is still missing.

Something else?

Tks.

>>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.
>
>You have not released excel is the reason that you are losing mem. Just closing the book does not automaticly release it.
>
>Try
>release MyExcel
>
>That should bring back your mem
>
>HTH
>Jeff
There´s a better life... Just it´s more expensive!
Cristóbal Manrique M.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform