Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Closing a link to an Excel app
I've got a little utility that uses OLE to open and interogate an Excel spreadsheet in VFP.
An abstract of my methodology:
WITH THIS
m.lcSrcXLS = GETFILE('XLS')
.hoExcelApp = CREATEOBJECT("Excel.Application")
IF NOT ISNULL(.hoExcelApp)
WITH .hoExcelApp
.Workbooks.Open(m.lcSrcXLS, .F., .T.) && readonly
.Workbooks[THIS.pnXlsWorkbook].Activate()
.Worksheets[THIS.pnXlsSpreadsheet].Activate()
ENDWITH
*** get information from the Excel spreadsheet
.hoExcelApp.WorkBooks(.pnXlsWorkbook).Close()
.hoExcelApp = .NULL.
ENDIF
ENDWITH
My problem is that when I leave the program, VFP still has a lock on the XLS file. I would have thought that the Closee() method would have broken the link into the XLS file, and NULLing the Excel object should have broken any ties to Excel.
What's missing?
TIA
Thom C.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement