Hi Sean,
strTotalDays = xlWB.Range("C22")
Your implying a WORKBOOK object. Workbooks don't have ranges.
Worksheets or sheets do.

Try strTotalDays = xlWB.sheets(sheetname).Range("C22")
Or strTotalDays = xlWB.sheets("sheet1").Range("C22")

--

John
johnf202 at hotmail dot com


"Sean" wrote in message
om...
Hi

I'm using VBScript to open an excel workbook and get some values from
the different worksheets. The problem is that one of the worksheets
creates an "Unknown Runtime Error".

The line on which the error arises is:
strTotalDays = xlWB.Range("C22")

After further investigation, it appears ANYTHING on this sheet seems
to create an error. There is also a hidden spreadsheet just before
that sheet - not sure if that has a problem. If I do the following:
For each objTemp in xlWB.Worksheets
msgbox objTemp.Name
Next

it will msgbox the names of all the sheets including the hidden sheet
and excluding the sheet I want!

Any ideas?