>Here's what I'm trying in a PRG, the direct CreateObject that's supposed to work generates a server error on my machine (I posted on that problem last week, but no one seems to have heard of it). Anyway, with a small table open:
>
>
>release oExcel
>_VFP.DataToClip(,,3)
>oTemp = GetObject('','excel.sheet')
>oExcel = oTemp.Application
>oExcel.Workbooks.Add()
>oRange = oExcel.Range("A1",Chr(65+FCount()-1)+Alltrim(Str(RecCount())))
>oRange.PasteSpecial()
>oExcel.Visible = .T.
>
>
>It appears to work (no errors), but Excel only briefly flashes at the Visible line, then closes. Can you see anything that might be causing trouble in my code?
Link Excel objects to form.property or oApp property if it's procedure
oApp.oTemp=GetObject('','excel.sheet')
etc.
Edward Pikman
Independent Consultant