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()
>oWorkbook2 = oExcel.Workbooks.Add()
>Now you can hop back and forth between Workbooks with no problem. With this approach, I didn't have problems in 97.