Hi,

I am trying to create a macro that will download many xml files into Excel, save them as a csv and store each one individually into a folder in the C drive. The URL is formatted as below:

http://www.sitename.come/date.xml

with the "date" being variable over the last year, from January 1st 2013 to December 1st 2013.

I am not very good with loops so I don't really know how to approach this- here is my code so far: 

Please Login or Register  to view this content.
Also I read somewhere that once an xml document has been mapped to a sheet it can't be overwritten with another map? So perhaps I would have to create multiple sheets to store all the XML documents?