Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need Help with Error #1426
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00453780
Message ID:
00456020
Views:
24
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform