Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Yet more excel trouble
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Yet more excel trouble
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
00980651
Message ID:
00980651
Vues:
97
yep still getting exception errors, is it just something that comes as standard if you expect to automate anything microsoft? I don't suppose anyone is currently automating excel simply opening updating and printing a sheet and getting stability? if so please talk to me. I actually get the full fox crashing exception error from the second line below, not often, maybe only 1 in 100 times the system runs through but when we run it a few hundred times day this having to restart a server based program is a big annoyance.

oExcel = CreateObject("Excel.Application")
oWorkbook = oExcel.workbooks.open(alltrim(basevars.baseljb) + "LaserJobbag.xls")

it's not some, "oh that file is busy" or "well actually oExcel is not an object" error, it's a fatal exception everything is dead jobbie.

again I know I've bugged you all on automating excel before but any help would be appriciated.

Oh and it's officexp with all the service packs and whatnot installed.

Ken.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform