We have a system which is used for document management, the server address is constant. The only thing that changes is the document Name/number. I have extracted a list of document numbers and concatenated them together with the server address. From the concatenated cells I have created a list of hyper links to the documents. I would now like to save the target of the hyperlinks to a directory on a local disk. Is this possible with VB code?
Any help would be much appreciated, I've been trying for 2 weeks to figure out a way to do this. There are around 2000 hyperlinks to save the target of meaning a manual approach is impossible.