Menu
I have a excel list with a lot of article numbers, eg. "23378847". And I want the pictures of all my article numbers in the list stored in my folder.
But the result will be as under. It should be 23378847.jpg not 152499
http://media.byggtjeneste.no/media/bilde/152499/LargeThumbnail
or
http://www.nobb.no/Nobbnr/OrginalBilde/23378847/152499
Is there a way that I can make a scrips that read my file and save the pic with the same article number as in the list?
570
Right click the URL, choose Open in a new tab. 6. In the new tab, right click the image and Save image as to then give the image a name and choose the destination on your pc to save it to.
One way is to use the "Get External Data" feature in Excel. To do this, go to the Data tab and click on "Get External Data." Then, select "From Web" and enter the URL of the page that contains the hyperlinked image. Once the page loads, you'll see a list of all the images on the page.
For those who don't want to deal with VBA or any other programming language there is a desktop web app that makes it super simple.
Just drop in the excel file, it will download all the images (or files) in an excel file to the folder you select, and if there are names on the B column it will also rename the file.
The latest release can be found on https://github.com/btargac/excel-parser-processor.
132
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
