Formula or VBA Macro for extracting a Hyperlink target file

[omidi_m]

Hi

I want a formula or a VBA Macro for extracting a series of hyperlinks target files and putting it into user-defined folder.
Will you please help me?

I know how to extract a hyperlink address and put it into a cell but I can find it enough for this purpose.


Regards

 

[hiker95]

omidi_m,

Can we see examples of the hyperlinks, and, what the results should look like?


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729

 

[omidi_m]

Dear Mr. hiker95

Thank you for answering me, but by the term "hyperlink" I meant hyperlink for files and folders in the local drives not the internet pages.

Now can you help me with this?

Thanks again

 

[hiker95]

by the term "hyperlink" I meant hyperlink for files and folders in the local drives not the internet pages.

omidi_m,

I do not understand what you are trying to do.

 

[omidi_m]

(Sorry for my bad English)

I have an Excel file with lots of hyperlinks (Which open some files in my "own" computer, (not internet)). I want to save all of these files into one folder without opening them and save them manually one by one by clicking on their links and selecting "Save as" ....

I want to know if there is any formula or VBA macro or any other automatic method for storing the file which is connected to a hyperlink into a folder. If I can find this formula the rest would be easy.

I should mention that all of these hyperlinks are in the same column. Maybe this makes it easier.

Thanks in advance.

 

[hiker95]

omidi_m,

I still do not understand what you are trying to accomplish.

Maybe someone else can assist you.


Please see Rule #12 at the next link on how to continue with your thread using BUMP.

https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html