How to make Dropbox image links in bulk?

If you are anyway related to the online industry you will definitely come across the need to make image links for the various portals such as amazon, flipkart, ebay, snapdeal and as well as your own online stores.

Creating image links one by one can be a very tedious and time taking. If creating links is a nightmare for you than I have good news for you, the perfect solution for you which is easy to implement.

In Dropbox we cannot create image links in bulk but there is a work around. Please use the below steps to achieve it:

STEP 1: Copy dropbox link for the folder you want to create the image links.

Step1

STEP 2: Open incognito mode in chrome, without incognito mode also it is possible but make sure you are not logged into your dropbox account.

Step2

STEP 3: Paste the dropbox link which you copied in STEP 1

Step3

STEP 4: Drag and select all the images in the folder and press CTRL+C (Copy all the images from the folder)

Step4

STEP 5: Press CTRL + V and paste all the image links in Column A in the sheet. After that click ALT+F11 to open module in macro. Check STEP 6.

Step5

STEP 6: Paste the below code in the module:

Sub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End Sub

Step6

STEP 7: Press ALT + F8 and run the macro ExtractHL

Step7

You will get the below error, but please ignore and click on End.

Step9

STEP 8: You will get all the links as below in the excel sheet.

Step8

If you think this tutorial made your life easy, please do share among the people who might need it. In case you face any issue please feel free to comment below.

11 thoughts on “How to make Dropbox image links in bulk?

Leave a Reply