I have a worksheet with folder names and image URL. I want to download each image to the specific folder from google drive link so that the outcome would look like this:
Folder Name Image URL store link(not in worksheet)
----------- ------------ -----------------------------------
example1 https://drive.google.com/drive/folders/example1 C:\images\example1\example1.jpg
example2 https://drive.google.com/drive/folders/example2 C:\images\example2\example2.jpg
example3 https://drive.google.com/drive/folders/example3 C:\images\example3\example3.jpg
example4 https://drive.google.com/drive/folders/example4 C:\images\example4\example4.jpg
example5 https://drive.google.com/drive/folders/example5 C:\images\example5\example5.jpg
Each link of google drive can have multiple images
I've found this VBA code, but I don't know how to add a method to creat folders: attaching file with code
Bookmarks