Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLE with Excel - I'm stumped
Message
From
03/07/2003 06:42:58
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00804575
Message ID:
00806465
Views:
38
>Cetin
>
>One more question if I may.
>
>I have tried to run the program on a numer of other machines and they all come up with the message OXLS is not an object. They all run win2kpro vfp6 sp5 and office 2000.
>
>1 machine has office 97 and it works beautifully even though the original spreadsheet was created in excel 2000. What am I missing? Any dcom/mdac settings? any ole settings?
>
>Any ideas?
>
>Colin

Colin,
I'd first check if that's a security issue (happens with default pre installations of Office by brand name computers - default security doesn't let object manipulation).

Try this on machines that it fails :

oExcel = createobject('Excel.Application')
oExcel.Quit

If it's a security thing then would fail on createobject line. Go and set permissions from DCOM then.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform