Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using xml to specify ranges
i'm not sure if this is possible at all, but i have a whole slew of the same xl spreadsheet with different data in them. my boss wants me to create a single spreadsheet that consolidates all of that data. which i have done. but recently that spreadsheet has been changed up some, and so the ranges i copy from are slightly different. now, i could go back and change each line of my code to different cells, BUT, i thought of a great idea. Why not just create an XML file that specifies, in order, which cells to copy from? then, i can specify versions of the spreadsheet and use the appropiate version of the xml file. problem is, i'm not too keen on XML in xl, and i have no idea how to get started. what i have right now is something like this: <?xml version="1.0" encoding="utf-8" ? <Ranges <Range page="1" name="Date" range="$C$6" / <Range page="1" name="Net1" range="$C$7" / <Range page="1" name="Manual Voids" range="$C$8" / <Range page="1" name="Net2" range="$C$9" / <Range page="1" name="WTDNet2" range="$C$11" / <Range page="2" name="Non-Reset Grand Total" range="$D$9" / </Ranges but how i can use that in xl, or if i even can is beyond me. what i would like to do is have some sort of looping code like: Sub loop() for each Range in Ranges 'copy and other actions next range end sub this is probably way to far fetched, but i can dream any help is appreciated, sven -- medicenpringles ------------------------------------------------------------------------ medicenpringles's Profile: http://www.excelforum.com/member.php...o&userid=16458 View this thread: http://www.excelforum.com/showthread...hreadid=494966 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how copy formula that contains ranges so ranges do not overlap | Excel Worksheet Functions | |||
Look up for a value in a s et of ranges | Excel Worksheet Functions | |||
Name Ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
named ranges - changing ranges with month selected | Excel Programming |