image auto downlod from multiple google folder link

.

Please Login or Register  to view this content.

Hi Logit,


thanks for your response.

This code is giving me "bad file name or number" error.

nad can you check with code in sample file attached, as even that need little modification as well, coz now even after execution i am not seeing any photos downloaded.

Hi,

any other code, which can help me to download images from google drive link, will be really great .
inculding one sample shared google link: https://drive.google.com/drive/folde...jYOWtldaDD--jy

.
You'll need to change the path in this line of code to match your computer :

Please Login or Register  to view this content.

As is, the above line is saving the file to my computer's name which is MY. Your computer most likely is named something different. It will be the name shown when you first boot up your computer.
If you are using WIN 10 for example it will say "Welcome My". Change the MY to whatever your computer name is.

And of course, it is saving the file to the Desktop in the above line.


Re-check the spelling of everything in the path line (shown above - for your computer) and recheck the Sheet Name as well. Is the sheet in question actually called SHEET1 ... or is it called something else
like perhaps "INVENTORY' or "DATABASE" or ???

Make certain the cell description in the path (shown as B2 above) is the actual cell you have the File Name entered.

Also keep in mind there are certain symbols that cannot be used in a file name because Windows won't accept them.

These are the common forbidden symbols folks try to use in creating file names :

Windows:

< (less than)
> (greater than)
: (colon - sometimes works, but is actually NTFS Alternate Data Streams)
" (double quote)
/ (forward slash)
\ (backslash)
| (vertical bar or pipe)
? (question mark)
* (asterisk)

Hi Leith,

sample link in example are non-existence.
providing a link of shared google drive folder.
https://drive.google.com/drive/folde...jYOWtldaDD--jy you need to login to your google account(perhaps gmail account) to access this link.

Hi logit,

thanks alot, that working perfectly, mistake which i was made, that i used "C:\Users\My\Desktop" instead of "C:\Users\My\Desktop\".

can you kindly check with sample file code to see, if any modification can be done to make it work, and to merge with your given code.

thanks in advance.