A search of the MSDN site didn't turn anything up, for me. Do you have
a URL or more for the information you did find?

In which application is this script running?

Please describe the actions of the code you're using. It would also
help to see the code, with the line marked that's causing the error.

Finally, which version of Office is involved?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)

According to the ErrorLookup utility from Visual Studio, this error is:
"The object invoked has disconnected from its clients. "

This is a COM/Automation error.  In general terms it means that the COM object
(server) you are trying to automate (probably Excel) has probably shut down.

When you say "close the workbook", do you mean that you are actually telling
Excel to quit?  I'm not sure if VBScript has a Set object = Nothing type of
statement like VB/VBA, but I believe that would also release the Excel object
and it would quit.

It sounds to me like something is trying to access Excel after you have "closed
the workbook".  Without seeing your script, it's hard to tell.

As a note, rather than automating Excel just to get a list of strings, you might
want to store them in a text file and use regular file access functions to read
the strings into an array (in VB/VBA, you could read the entire file into a
single String variable and then do a split on vbCRLF to create your array with
just a couple of lines of code), or you could use ADO to read the Excel
spreadsheet file as if it was a database (very easy to do, just get the
connection string correct, and then each worksheet in the workbook represents a
table in the virtual database, no Excel required).