Pete at Sappi Fine Paper shared this with us in
microsoft.public.excel.programming:

Hi folks.

The Workbooks keyword only seems to work for spreadsheets that are
already open. I can't seem to say, for example:

wkb = Workbooks("Y:\Downloads\6-7.xls")

So how do I refer to cells in that spreadsheet without opening it?

Any help would be much appreciated! :)

-Pete

Read this page:

Copy a range from closed workbooks (ADO)
http://www.rondebruin.nl/ado.htm

And this also:
http://www.rondebruin.nl/tips.htm

It's not a direct answer to your question, but a good workaround.

--
Amedee Van Gasse