>Hi, could someone please help. I am using the code below to open an Excel worksheet in a Foxpro v6 application. From the command window I don't have a problem, but when I compile the app, the Excel worksheet momentarily displays and then diappears. What am I doing wrong? Any help would be appreciated.
>
>** code being used
>gfile=getfile("xls")
>
>If !empty(gfile)
> oleApp = createobject("Excel.Sheet")
> oExcel=oleApp.Application
> oExcel.Workbooks.Add(gfile)
> oleApp=getobject(,"Excel.Application")
> oleApp.Application.visible=.t.
>Endif

Getobject() quit working for me in vfp6 also. Do something like this:

oExcel = createobject("Excel.Sheet")
oExcel.Workbooks.Add(gfile)
oExcel.Visible = .t.

You may need to make oExcel a form property, and use a local like oSheet as:

oSheet = Thisform.oExcel.Activesheet

to manipulate it.