Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

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?

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 : {http://www.asdfgafdgqwe.gr//application/images/big/140-0843.jpg}
 
(the first questions was for the extraction of the thumpnails)

the next question is to download in batch mode this photos with a macro ?
thanks
0
rodojohn
Asked:
rodojohn
  • 2
  • 2
1 Solution
 
Nico BontenbalCommented:
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, "http://www.asdfgafdgqwe.gr//application/images/big/140-0843.jpg", "c:\140-0843.jpg", 0, 0
0
 
rodojohnAuthor Commented:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27024989.html
this the related question
i  have a column with links in excell like "http://www.asdfgafdgqwe.gr//application/images/big/140-0843.jpg that all points to jpg  , i need a macro ? that downloads the links (from the specific column) and saves all jpg to selected folder.
0
 
Nico BontenbalCommented:
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.

Jpg.xlsm
0
 
rodojohnAuthor Commented:
it works , thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now