XML equivalent of VBA's XLdown
 

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

XML equivalent of VBA's XLdown
 

Sorry that post should read...

XLM equivalent of VBA's XLdown and not XML

Still coming to grips with the different programming languages.