Can I enquire on the size of a range in an unopened worksheet?

The line below doesn't work:
J = Workbooks("C:
\MyTables.XLS").Worksheets("cs_Tables").Range("CS_ Names").Rows.Count


Thanks in advance,

Greg