Excel downloader for a list of URLs

Hi

I am after a file downloader to do a specific task using excel.

In short, we have Sharepoint. We can file our documents away to a Record Management Service, which is all fine. But trying to retrieve multiple files back once filed is an exercise in frustration, since every document has to be clicked in Sharepoint for it to then download from the RMS.

So if there is a library of 100 documents (all of which are filed to the RMS) and we need copies of these files for a USB stick or to put in another library, we have to download all 100 of them one at a time by clicking, waiting, saving and repeating.

The url for this function when we click is:

Sharepointsite.com/_layouts/RMS/Redirect.aspx?Action=GetFile&item=RMS://EDR1/Record[Extension=docx]/2403589&target=sharepointsite.com/Documents/Example.doc

In actuality, this is what happens when downloading directly from the RMS site

edr1.uk/RMS/browse/downloadContent.aspx?documentId=2403589&isRecord=true&launchMode=3&launchAs=0&OverrideLatestRecordVersion=true

You can see that the file id is key here. Both above URLS work on our system fine and both get the document in IE to display a open or save dialogue.

I can produce a spreadsheet with all these details In, I think. So there would be a list like

edr1.uk/RMS/browse/downloadContent.aspx?documentId=2266772&isRecord=true&launchMode=3&launchAs=0&OverrideLatestRecordVersion=true
edr1.uk/RMS/browse/downloadContent.aspx?documentId=2288772&isRecord=true&launchMode=3&launchAs=0&OverrideLatestRecordVersion=true
edr1.uk/RMS/browse/downloadContent.aspx?documentId=2288789&isRecord=true&launchMode=3&launchAs=0&OverrideLatestRecordVersion=true
edr1.uk/RMS/browse/downloadContent.aspx?documentId=2556472&isRecord=true&launchMode=3&launchAs=0&OverrideLatestRecordVersion=true

How can I get excel to take this list and download the files? If this even is possible?

So excel will try to get the document at each URL and save it to a pre-defined location.
I am unsure if there is a connection limit, so even limiting excel to downloading one at a time is still fine, since it saves the hassle of having to click each one.

This possible?