Mass hyperlinking images?

[j4k3y]

Hihi,

The question I have is, with a sheet which looks like

website1.com
website2.com
website3.com


And a directory of screenshots named after the website, website1.com.png, website2.com.png etc etc

Is there a way to mass hyperlink these images? If not, what would be the best way to go about this?

Thanks!

[elayaz]

Hello,

If you are using windows.. Using command prompt.. Navigate to the directory which has the screen shot images and type the following command..

DIR /B /O:N > filename.txt

This command will save all the file names (only) as txt file in the same directory itself. Now copy the folder path of the images location.

In excel, Paste the folder path in a column. Copy,paste the file names in next column. Use CONCATENATE() and use hyperlink().

Let me know if this solved your issue. See the attached example.

mass_hyperlink.xlsx

-------------------------------------------------------------

Please close this thread if your issue is solved.
Click the star icon * in the lower left part of the contributor's post and add Reputation