Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PUTTING VBA'S TOGETHER | Excel Worksheet Functions | |||
Bug in Excel's (not VBA's) MOD function | Excel Discussion (Misc queries) | |||
Bug in Excel's (not VBA's) MOD function | Excel Worksheet Functions | |||
wats the best way for learning Macros, vba's etc | Excel Programming | |||
VBA's Future | Excel Programming |