PRB: RELEASE May Not Remove OLE Objects from Memory

RESOLUTION

For Visual FoxPro to remove certain OLE application session objects from memory, the OLE application must be terminated. For example, after running the following code, three instances of Microsoft Excel remain in memory:

   FOR i = 1 TO 3

       oObject = CREATEOBJECT('Excel.Application')
       RELEASE oObject

   ENDFOR
				

To end each Microsoft Excel session before reentering the FOR loop, the Microsoft Excel session must first be terminated. For example:

   FOR i = 1 TO 3

       oObject = CREATEOBJECT('Excel.Application')
       oObject.Quit
       RELEASE oObject

   ENDFOR
				

In this example, Microsoft Excel is told to quit, and then the code releases the memory variable in Visual FoxPro by using the oObject.Release command. Quit is a method that Microsoft Excel recognizes and can act upon, the actual method for your OLE automation application may differ.