vba google search on chrome from excel

mbasith · #1 10-25-2018, 06:16 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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