G
Guest
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
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