Jeana,

This will open up a spreadsheet:

oExcel = createobject( "excel.application" )
oExcel.Visible = .t.
oExcel.Workbooks.Open( "TheSpreadsheet.xls" )

This will bring it to the foreground;

DECLARE INTEGER SetForegroundWindow IN WIN32API INTEGER
SetForegroundWindow( oExcel.Hwnd )

The user can do what ever they want inside Excel.

If they shutdown Excel then you can test it from inside VFP:

if ( type( "oExcel.ActiveWindow" ) = "U" )

Then you can just get rid of your object with:

oExcel = .null.

>1. Open an excel worksheet within VFP ( How To ???)
>2. Let the user update excel work sheet
>3. If user clicks “close” in excel , close the excel sheet in prg. (How To ??)
>4. Get on with my program.