Manipulating Excel through VFP 1

[SGLong]

I've been able to create and manipulate an Excel spreadsheet from within VFP. When I close the save and close the spreadsheet (see code below), the XLS file is still tagged as being 'in use' and there is an instance of Excel running when I press a Ctrl-Alt-Del. How do I successfully close the file and terminate Excel?

** Code from tail end of my program...
oExcel.ActiveWorkbook.Save
wait window 'Saving updated spreadsheet...' timeout 3
release oExcel
close data all

 

[foxdev]

I had this same experience with Word using its COM interface. I think what you need, before the RELEASE statement, is:

[tt]oExcel.Quit[/tt]

That should do the trick.