If you are anyway related to the online industry you will definitely come across the need to make dropbox 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.
Although, Dropbox can’t 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.
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.
STEP 3: Paste the dropbox link which you copied in STEP 1
STEP 4: Drag and select all the images in the folder and press CTRL+C (Copy all the images from the folder)
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.
STEP 6: Paste the below code in the module:
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
STEP 7: Press ALT + F8 and run the macro ExtractHL
You will get the below error, but please ignore and click on End.
STEP 8: You will get all the links as below in the excel sheet.
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 or email at email@example.com.