Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OLE with Excel - I'm stumped
Message
De
03/07/2003 06:42:58
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00804575
Message ID:
00806465
Vues:
37
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform