Thank you for your macro it seems to work:
I have a little bit of understanding in VBA however I do not understand how your code connects to the Internet.
I am assuming that the function Internet GetFile is the one that is connecting to the Internet.
And that all the Const are some kind of ports.
I will appreciate if you can explain more how this works.
Also I would like to be able to resize photos if the resolution is smaller then 800 x 800 pixels to 825 x 825 however when I resize I would like to keep the original ratio but that at least the length and height are equal or bigger than 825 pixels.
I was playing around with your code and I made it a bit more flexible.
I added another macro called " Main_module"
It has a macro Main_save_files
I added the following options:
1.VBA builds a folder name based on the SKU name.
2. I built a loop that can work with multiple SKU'S
I am attaching a workbook with all the new code.
You can also find the code that builds folders here:
And the code the code that downloads the photos here
Thank you again for your help.
Bookmarks