drizzt81

yay. I had wished for a tool like this. Thanks, it looks really sleek. I don't have vista yet, but I will give it a whirl when I do

I have already tried that. While i have yet to write an XML schema to go along with my data, I don't think that excel's XML support allows a single XML file to be translated into multiple worksheets, which is what I would like to do. Since I wrote that program, I could do that. However, I think that the same problem applies that the XML file is causing: Excel interprets a single CSV file as a single worksheet. Since my data has more than 2 dimensions (Statistic Name, Run, Step) and I have tens of runs with hundreds of steps, dropping it all in a single worksheet would make working with data pretty hard. I had not thought of that idea. I will look into it, unfortunately my VBA skills are close to zero. thanks for your ideas, I appreciate your input. Greg

Hello, I have a program that generates a lot of data (statistics from my simulation) and since it is multi-dimensional data, I felt that an XML file would be a smart way to store it (and somewhat portable). I particular a single XML file stores multiple Statistics for each run. the value is stored for each step inside of a run, giving this type of XML source: <STATISTIC Name="Token moves"> <RUN INDEX="0"> <DATA INDEX="0" TYPE="INT">20</DATA> <DATA INDEX="1" TYPE="INT">25</DATA> <DATA INDEX="2" TYPE="INT">25</DATA> <DATA INDEX="3" TYPE="INT">25</DATA> </RUN> <RUN INDEX="1"> <DATA INDEX="0" TYPE="INT">20</DATA> <DATA INDEX="1" TYPE="INT">20</DATA> <DATA INDEX="2" TYPE="INT">20</DATA> </RUN> </STATISTIC> I would like to import this data into excel with each Statistic getting a single spreadsheet, runs across and steps down. Is this possible, if so, how?