Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2018, 06:16 AM
mbasith mbasith is offline vba google search on chrome from excel Windows 8 vba google search on chrome from excel Office 2010 64bit
Novice
vba google search on chrome from excel
 
Join Date: Oct 2018
Posts: 5
mbasith is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 10-25-2018, 08:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline vba google search on chrome from excel Windows 7 64bit vba google search on chrome from excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 10-25-2018, 12:13 PM
mbasith mbasith is offline vba google search on chrome from excel Windows 8 vba google search on chrome from excel Office 2010 64bit
Novice
vba google search on chrome from excel
 
Join Date: Oct 2018
Posts: 5
mbasith is on a distinguished road
Default

Sure... I did not break any rules..
Reply With Quote
  #4  
Old 10-26-2018, 12:20 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline vba google search on chrome from excel Windows 7 64bit vba google search on chrome from excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #5  
Old 10-26-2018, 05:34 AM
mbasith mbasith is offline vba google search on chrome from excel Windows 8 vba google search on chrome from excel Office 2010 64bit
Novice
vba google search on chrome from excel
 
Join Date: Oct 2018
Posts: 5
mbasith is on a distinguished road
Default

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..
Reply With Quote
  #6  
Old 10-26-2018, 06:37 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline vba google search on chrome from excel Windows 7 64bit vba google search on chrome from excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by mbasith View Post
I did not know them previously..

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
Reply With Quote
Reply

Tags
google search, vba excel

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Excel worksheet from Google sheet tasneemj Excel 0 02-11-2018 12:17 PM
vba google search on chrome from excel Error in exporting Google Sheet to Excel cmcmeekin Excel 2 08-03-2016 11:32 AM
vba google search on chrome from excel =filter() feature of google sheets not in EXCEL peter.threepins Excel 1 07-13-2016 08:44 AM
vba google search on chrome from excel 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft