+ Reply to Thread
Results 1 to 16 of 16

Google image search from cell contents of excel file

  1. #1
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Google image search from cell contents of excel file

    Hi, i have an excel file with hundreds of rows of product codes which i need to download images for. is there a way this can be done directly from excel?
    basically if cell A1 has product name and Cell B1 have product code, id like Cell C1 to generate a link that will use the contents of B1 as the basis of my google image search. can this be created using a macro?

  2. #2
    Registered User
    Join Date
    02-23-2014
    Location
    Michigan, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Google image search from cell contents of excel file

    Something like this?
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Google image search from cell contents of excel file

    Thanks @ SnarlingSheep
    Although i dont have any idea how to implement this. is it possible for you to create an excel file with this code in it so that i can see how its done?

  4. #4
    Registered User
    Join Date
    02-23-2014
    Location
    Michigan, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Google image search from cell contents of excel file

    I used a button (Developer Tab > Insert > Command Button (Active X Control))
    In Design Mode (Developer Tab > Design Mode) you can right-click the button and click 'View Code' which will open the VBA editor to the button click event.
    Replace the default code with the code that I gave you.

    I've also attached an exampe sheet.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Google image search from cell contents of excel file

    Thank you sooo much SnarlingSheep. you a genius, this is exactly what i need.

  6. #6
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Google image search from cell contents of excel file

    Problem!!!
    im getting a Run time error 13 : Type mismatch

    what is this error

    ive attached the file
    GoogleImageSearchLinks-2.xlsm
    Last edited by merQrey; 04-06-2014 at 02:30 AM.

  7. #7
    Registered User
    Join Date
    02-23-2014
    Location
    Michigan, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Google image search from cell contents of excel file

    I was checking the Cell for contents incorrectly.
    Try this instead.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    02-23-2014
    Location
    Michigan, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Google image search from cell contents of excel file

    If you would like it to automatically add the link when a product code is put in, in place of the button code put this:
    Please Login or Register  to view this content.
    Then you can delete the button

  9. #9
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Google image search from cell contents of excel file

    Awesome thanks alot my friend. you really have shaved hours off from my workload
    keep up the great work

  10. #10
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Google image search from cell contents of excel file

    Hi @SnarlingSheep
    i was wondering if you can assist once again on this topic. based on the search criteria that you have written the code for in the above example, is it possible for you to add to that code the ability to auto save the very first image that google finds (preferably large image sizes) under each search criteria to a specific folder

  11. #11
    Registered User
    Join Date
    08-27-2015
    Location
    ankara
    MS-Off Ver
    2013
    Posts
    2

    Re: Google image search from cell contents of excel file

    same question here, is it possible to auto save first image that google finds under the specific folder with the name of cell b1, b2 etc?

  12. #12
    Registered User
    Join Date
    02-06-2019
    Location
    Indonesia
    MS-Off Ver
    2010
    Posts
    2

    Re: Google image search from cell contents of excel file

    Quote Originally Posted by SnarlingSheep View Post
    I used a button (Developer Tab > Insert > Command Button (Active X Control))
    In Design Mode (Developer Tab > Design Mode) you can right-click the button and click 'View Code' which will open the VBA editor to the button click event.
    Replace the default code with the code that I gave you.

    I've also attached an exampe sheet.
    ill try it

  13. #13
    Registered User
    Join Date
    02-06-2019
    Location
    Indonesia
    MS-Off Ver
    2010
    Posts
    2

    Re: Google image search from cell contents of excel file

    how to make button like this? any tutorial

  14. #14
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Google image search from cell contents of excel file

    Hi netalia2015,

    Unfortunately your post does not comply with Rule 4 of our Forum RULES.

    Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    HTH
    Regards, Jeff

  15. #15
    Registered User
    Join Date
    01-04-2010
    Location
    Charlottetown, PE
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Google image search from cell contents of excel file

    Did anyone have any luck with the Auto-Saving the first image? Thanks for the code, works great!

  16. #16
    Registered User
    Join Date
    07-24-2020
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    1

    Re: Google image search from cell contents of excel file

    Great help so far.. I also would like to see if auto saving is an option and also we can set image quality (filter)

+ 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. [SOLVED] how to search google using cell values in microsoft excel 2010
    By Julii in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 09-16-2013, 09:31 AM
  2. Google search from Excel
    By b53fj in forum Excel General
    Replies: 1
    Last Post: 01-17-2013, 11:50 PM
  3. Macro help - use cell contents for Google search
    By tomwsanchez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2012, 08:26 PM
  4. search google from excel
    By amitbronstein in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2010, 08:25 AM
  5. Replies: 0
    Last Post: 11-05-2009, 04:47 AM

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