#1
|
|||
|
|||
vba google search on chrome from excel
Hello friends,
I have macro which opens IE but unable to search for the keyword of the cell C3, i need modification that, instead of IE, it need to open chrome browser when combo keys eg:. CTRL+SHIFT+E -- macro should go that particular cell say C3 and would pickup that keyword search directly in chrome to show the possible result Appreciate your help in this regard, Thanks, Code:
Sub Macro1() ' ' Macro1 Macro ' chrome google search ' 'Keyboard Shortcut: Ctrl Shift + E Dim s As String Dim IE As Object Range("C3").Select ActiveCell.FormulaR1C1 = " " Range("C3").Select s = Selection.Copy 's = InputBox("Enter ur search key", "Key") Set IE = CreateObject("InternetExplorer.application") IE.Navigate "https://www.google.co.in/search?q=" & s IE.Visible = True While IE.busy DoEvents Wend Set IE = Nothing End Sub |
#2
|
||||
|
||||
Are you willing to follow the forum rules this time, or do you still don't care?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Sure... I did not break any rules..
|
#4
|
||||
|
||||
Short memory. You never bothered acknowledging my requirement, let along add a link as asked
https://www.msofficeforums.com/excel...cell-cell.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
Sorry for the comments. I acknowledge the Rules are for everyone.. and me... No problem..I did not know them previously..
Thank you, could you reply this query.. |
#6
|
||||
|
||||
I will leave it at that, but your history of cross posting ( also as meer_ali) is not promising...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
google search, vba excel |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update Excel worksheet from Google sheet | tasneemj | Excel | 0 | 02-11-2018 12:17 PM |
Error in exporting Google Sheet to Excel | cmcmeekin | Excel | 2 | 08-03-2016 11:32 AM |
=filter() feature of google sheets not in EXCEL | peter.threepins | Excel | 1 | 07-13-2016 08:44 AM |
Adding Google Search to Words right click menu | TVTime | Word | 1 | 01-08-2015 11:53 PM |
Adding a google search to Word | alexb123 | Word | 0 | 03-23-2011 04:30 PM |