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:
In actuality, this is what happens when downloading directly from the RMS site
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
How can I get excel to take this list and download the files? If this even is possible?
I think an issue might be the fact that the URLs are not direct. They go through another process (forget the technical term). So it goes through an .aspx and then a ID to get the file. Unsure if excel vba can assist me here but I am hoping so.
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.