try this....
Sub test()
Dim x As Excel.Workbook
Set x = Workbooks.Open("c:\book4.xls")
End Sub
Swap "book4.xls" for your workbook name.
Good luck.
--
www.alignment-systems.com
"Pete at Sappi Fine Paper" wrote:
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