I want to import multiple ranges from multiple workbooks without opening
them. To do this I use the proceedure from J Walkenbach, nested into For Next
loops...

arg = "'" & path & "[" & filename & "]" & sheet & "'!" & Ref

Range = ExecuteExcel4Macro(arg)

My problem is the ranges are not uniform length. Does XML have an equivalent
to VBA's XLdown?

Using the Macro Recorder, 'Ref' would look something like (can it be
shortened to 1 line of code?)...

Range("AJ23").Select
Range(Selection, Selection.End(xlDown)).Select

I am running Office2003.

Thanks for any advice

Nick