+ Reply to Thread
Results 1 to 10 of 10

Extracting Multiple .jpeg Images link in a folder

  1. #1
    Registered User
    Join Date
    06-21-2016
    Location
    Canada
    MS-Off Ver
    10
    Posts
    5

    Lightbulb Extracting Multiple .jpeg Images link in a folder

    Hi,

    I am new to Excel and no idea bout VBA. I have excel sheet with 100 images link. Its not hyperlink. I have to copy paste that link in broswer to see image. Its in .jpeg format. something like " https://xxxxxxx/xx/xx/image.jpg"

    I want to download all these images all together in one folder.

    Is there way to do it intelligently? By running Macro?

    I tried to run few Macro's from internet but being nooby No success till now. I think those macros are for to extract image from hyperlink. But this is not hyperlink.Its just address.

    Can somebody help me with correct Macro?

  2. #2
    Forum Contributor
    Join Date
    03-22-2016
    Location
    Philippines
    MS-Off Ver
    MS Office 2013
    Posts
    124

    Re: Extracting Multiple .jpeg Images link in a folder

    Try SeqDownload software of nirsoft.net instead of doing it in Excel.

  3. #3
    Registered User
    Join Date
    06-21-2016
    Location
    Canada
    MS-Off Ver
    10
    Posts
    5

    Re: Extracting Multiple .jpeg Images link in a folder

    i dont think you can download multiple image at a time with SeqDownloader.

    Can you tell me if there is a way to do it?

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Extracting Multiple .jpeg Images link in a folder

    Hello bhushh009,

    Add a new VBA Module to your workbook. Copy and paste the code below into it.

    Make any needed changes to the code with comments. Run the macro named CopyWebPicsToFolder. If an error occurs, you will be notified and the macro will stop.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  5. #5
    Registered User
    Join Date
    06-21-2016
    Location
    Canada
    MS-Off Ver
    10
    Posts
    5

    Re: Extracting Multiple .jpeg Images link in a folder

    I am getting error no 9 " Subscript out of range".

    I did change as per my excel sheet.

    As per your code,
    Set Wks = Worksheets("Sheet1").....Change this to the worksheet with the URLs.
    I think i am doing it wrong here. How to give URL?

    I am configuring
    Set Wks = Worksheets("Sheet2").. as all the images are in sheet2. Is it wrong?

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Extracting Multiple .jpeg Images link in a folder

    Hello bhushh009,

    From your first post, I understand that you had the URL of each jpg file to be download in a cell on a worksheet. For example, "Sheet2" cell "A1" contains a URL like"http://mobileimages.lowes.com/product/converted/503763/50376310.jpg"

  7. #7
    Registered User
    Join Date
    06-21-2016
    Location
    Canada
    MS-Off Ver
    10
    Posts
    5

    Re: Extracting Multiple .jpeg Images link in a folder

    Correct.!!!!
    Thats how i have more than 100 url in K2, K3, K4,K5 etc respectivly

    "http://mobileimages.lowes.com/product/converted/503763/50376310.jpg"- K2
    "http://mobileimages.lowes.com/product/converted/503763/50376311.jpg"- K3
    "http://mobileimages.lowes.com/product/converted/503763/50376312.jpg"-K4 and so on....

  8. #8
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Extracting Multiple .jpeg Images link in a folder

    Hello bhushh009,

    I have cjamged the lines in green for you. The worksheet name is "Sheet2" and the first cell of the URL list is "K2". You will need to change the line in red to match the folder name you are using to store the pictures.
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    06-21-2016
    Location
    Canada
    MS-Off Ver
    10
    Posts
    5

    Re: Extracting Multiple .jpeg Images link in a folder

    Perfcte. It worked like charm.

    Thanks Ross.

  10. #10
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Extracting Multiple .jpeg Images link in a folder

    Hello bhushh009,

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel vba code required to insert jpeg images into sheets and delete unused.
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2015, 08:01 AM
  2. Replies: 2
    Last Post: 12-08-2014, 06:04 AM
  3. Macro to match jpeg images to cell values
    By eoghanmolloy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2014, 09:59 AM
  4. Re-sizing JPEG Images
    By Matty5894 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-09-2014, 12:14 PM
  5. Extracting JPEG data to Excel
    By hkwat in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-18-2013, 06:10 AM
  6. Extracting JPEG data to Excel
    By hkwat in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-09-2013, 12:20 AM
  7. Replies: 2
    Last Post: 06-18-2013, 12:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1