!VBA - Looping a web query with referenced cells

[Crazzled]

Sorry if this is in the wrong place, I'm a first time poster. After a few guides I'm still having trouble doing what I set out to do.

I'll start off with the basis on the spread sheet, so let's say in Excel, I have;


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Place[/TD]
[TD]BHX1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Date From[/TD]
[TD]04/10/13[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Time From[/TD]
[TD]21:00:00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Date To[/TD]
[TD]05/10/13[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Time To[/TD]
[TD]03:00:00[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]User[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]JohnSmith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]JaneDoe[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]...[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I'm trying to create a macro that will generate, a web query, onto a new page, a table from;

https://bhx1-portal.com/fc-cgi/pick...om=10/05/2013+00:00:00&to=10/05/2013+21:38:29

Where the date is taken from the cells above. Then I would like it to take the value of JohnSmith directly from the A8 cell and for it to loop for A9, A10, A11... Until the value taken is blank.

Any ideas? Anyone that does answer is it possible you could explain it? So I can develop the knowledge?

Thank you!