Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need Help with Error #1426
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00453780
Message ID:
00456020
Vues:
25
Thanks, Della!

That will be good to keep in mind in the future. Until then, what I've already done should work.

---Michael

>There *is* a difference between how '97 and 2000 handle multiple instances of the application object. 2000 handles it nicer than 97, which may be why your one client is experiencing problems. My recommendation is to open ONE instance of the Application object, and TWO instances of the Workbooks objects, as in:
>
oExcel = CreateObject("Excel.Application")
>oWorkbook1 = oExcel.Workbooks.Add()  && Or use Open(), whichever is needed.
>oWorkbook2 = oExcel.Workbooks.Add()  && Or use Open(), whichever is needed.
>Now you can hop back and forth between Workbooks with no problem. With this approach, I didn't have problems in 97.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform