Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel worksheets in VFP6
Message
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00316031
Message ID:
00316215
Views:
21
>Hello Bruce, John, and all others involved in this thread,
>
>I just tested the following lines in VFP6.0:
>excelsheet = getObject("c:\windows\desktop\a.xls")
>excelsheet.application.visible = .t.
>
>Assuming a file a.xls already exists on my desktop, it gets the object, and makes it visible to me. From what I'm understanding in this thread, it was said that this cannot be done in VFP 6.0. Is there perhaps a different problem, or am I misunderstanding the thread? I must, however, agree that whenever possible, the createObject() is better anyways. I just wanted to voice some opposition to the notion that you CAN'T use getObject for excel in VFP 6.0

I know mine would not stay visible in runtime with Getobject in vfp6, the exact same code that worked fine in vfp5, all vars made Public to be absolutely certain. Note that you must test these things in a runtime EXE situation, the Command Window is no good because it may give different results. Also, I was using Getobject to create a new XLS file, so that could alter things, too, I guess...but Getobject definitely does not work with Excel97/vfp6(SP3) when creating a new file, that much I'm quite sure of, I spent quite a while testing it.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform