Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to view an Excel worksheet?
Message
 
General information
Forum:
Visual FoxPro
Category:
Windows API functions
Miscellaneous
Thread ID:
00048405
Message ID:
00048573
Views:
26
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.com

Never mistake having a career with having a life.
Previous
Reply
Map
View

Click here to load this message in the networking platform