13th February 2013, 01:17 PM
|
|
Member
|
|
Join Date: Mar 2006
Posts: 112
|
|
Excellent, stugots.
Works brilliantly.
For the rest I altered the code to -
Code:
A = 3
Address = Sheets("Sheet2").Cells(A, 1)
xmldoc.Load Address
then at the end of the macro - A = A + 1
so that the next pass A = 4 ie. Cell(A4)
Thanks again, mate
Den |