You could also just put an ExcelWorksheet OLEControl onto your form.
>>>What is the best way to view a spreadsheet? I'm currently using a "RUN" command followed by the file name but this displays the "Foxrun" command window (big black box).
>>>
>>>Is there another, more elegant way to do this?
>>>
>>>Thanks in advance
>>
>>Hello,
>>
>>Excel is an EXCELLENT OLE server (i have used it extensively).
>>Anything you do think of with Excel can be nicely requested from fox.
>>
>>Try this (should work with recent versions of Excel) :
>>
>>oExcel=getobject(getfile("xls"))
>>oExcel.windows(1).visible=.t.
>>oExcel.application.visible=.t.
>>
>>you can, of course do much more,
>>
>>François
>
>This looks like exactly what I need but I get an error message when I try it.
>
>The message is "OLE object does not have a windows property" so the second line crashes.
>
>Are you setting up a form with an OLE object on it? Is this object named oExcel? Is there a CommandButton with this code in the 'Click' event?
>
>Thanks in advance.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.