In the same xlsx file i have a colum with product_code_ID data , could i take the filename of the images from the cell of the specific row?

Posted on 2011-05-11
Last Modified: 2012-05-11
In the same xlsx file i have a column with product_code_ID data ,
could i take the filename of the images from the cell of the specific row ?( alternative method )  in batch mode

also i can make a column with a specific web address which point to the link of the big detail photos                                ( like : {}
(the first questions was for the extraction of the thumpnails)

the next question is to download in batch mode this photos with a macro ?
Question by:rodojohn
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    Not sure I completely understand your question but when you put this in the header of a module:
    Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long

    Open in new window

    You can use this to download the file:
    URLDownloadToFile 0, "", "c:\140-0843.jpg", 0, 0

    Author Comment

    this the related question
    i  have a column with links in excell like " that all points to jpg  , i need a macro ? that downloads the links (from the specific column) and saves all jpg to selected folder.
    LVL 22

    Accepted Solution

    See the attached example. The SaveJPG will download all pictures in the sheet to the folder the file jpg.xlsm is in, with the productid as the name.


    Author Closing Comment

    it works , thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    Use email signature images to promote corporate certifications and industry awards.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now