Hi All
I have excel sheet with keywords in column A
I need a Macro which should help in taking me to Google chrome images when I click on any keyword.
kindly Advise
Regards
Kiran Kumar
Hi All
I have excel sheet with keywords in column A
I need a Macro which should help in taking me to Google chrome images when I click on any keyword.
kindly Advise
Regards
Kiran Kumar
Hi
All you need to do is create a Hyperlink from the link cell which points to you Chrome image/filename.
Go to the cell which requires the link and pesee Ctrl+K and complete the required questions that are presented.
You don't need a Macro.
Tony
Thanks for the reply Tony...
You I have a number of keywords in a column A..I need to go google images to see the image of that keyword by clicking on that particular key word...
please advise
I have enclosed a file for your persual
thank you
Kiran Kumar
Is the web browser Google Chrome or can IE be used? The code is different for invoking and sending the data to the web browser.
Please click * if the answer was helpful.
I have both the browsers on the systems.... I am okay with any browser.... This code will help us in reducing alot of manual effort... kindly help
Thanks
Regards
Kiran Kumar
Add code snippet to your worksheet. Alternatively, pull out the code into a module and call it from the worksheet, passing in the range or search string. The latter will allow the code to used by other worksheets.
Tried and tested on IE8. Note, that this currently opens a new IE window and not use an existing open IE window.
Hope that helps.
Please Login or Register to view this content.
Hi yeng thanks for the code.... I am a bit slow in understand the code....
I have keyword in A1 row... where should I place range A1 in the above code
Hey Yeng Thanks for the code it worked for me..... Thanks a lot..... wonderful...
one more question... can we restrict it to only one column in the sheet rather than all the columns and it should be click base rather than scroll
Code updated with the following:
- Pulled out the generic search string and made it a const
- Check that the range selected is in column 1 - you need to update to the required column(s)
- Check that the range consists of only one cell (this is what I assume you mean by "click base rather than scroll")
Hope the updates fulfills your requirements.
The code is as follows:
Please Login or Register to view this content.
Hi Yeag... I appreciate your help on this... right now I am able to restrict the query to only one column which is fantastic....
The only problem I have is... when I have cut my cursor on the keyword... the inter net explorer automatically poping up...
but I want the internet explorer to open only when I click on the key word rather then just placing a cursor on the keyword.... so i can even copy my keyword without opening the internet explorer
Thanks for your patience in understanding me and helping me
Regards
Kiran Kumar
OK. I understand you and I see the issue, which is, whenever you use the cursor to navigate over these cells the IE pops up and it makes it impossible to copy the keywords.
I had a quick online for capturing onclick and cell selection and found that the solution is to only activate the google search when you double click on the cell. I have tested this it resolves the unnecessary opening of IE and can use keyboard cursor or mouse click to select the cells for copying.
Update the method from:
to:Please Login or Register to view this content.
Hope this helpsPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks