Thanks, GMan...that helps a lot in posting the data. I had the mindset
that each client had to be posted before the data could be collected
for the next client.

I'm an SQL person, so I'm not accustomed to making reports look pretty!
I usually save the results of a query as a CSV file and send it to
them. This page scared the bejeesus out of them, so they sent it to me
to fix it.

Unfortunately, the extraction of the data from the HTML tags is more
complicated. Would it be more efficient to clean up the raw data
before the Array is created or can I call the clean up/extraction
procedure here, instead of MID....?

ClientArray(intClient, intData) _
= Mid(shSource.Cells(intClient, 1), _
(intData - 1) * 20 + 1, 20)

Here's a sample of the first few rows of the raw data. The way I find
the start of information for a new client is the <Date> tag. I also
use the <Date> to count the number of clients. I have a separate
procedure that uses a For Each...Next loop to cycle through the raw
data collecting the 16 data elements that relate to a client. This
garbage repeats over and over for each client (usually around 100
separate clients).

<?xml version="1.0" encoding="UTF-8" ?>
* <!DOCTYPE EnrollOnlineClient (View Source for full doctype...)>
- <EnrollOnlineClient version="1.0">
- <Control>
- <Timestamp>
- <Date>
<Year>2005</Year>
* <Month>11</Month>
* <Day>16</Day>
</Date>
- <Time>
* <Hour>04</Hour>
* <Minute>45</Minute>
* <Second>01</Second>
* </Time>
* </Timestamp>
* </Control>

Thank you so much for your help!


--
DataCollector
------------------------------------------------------------------------
DataCollector's Profile: http://www.hightechtalks.com/m368
View this thread: http://www.hightechtalks.com/t2295175