View Full Version : Search Internet
Djblois
08-17-2007, 07:27 AM
I want to create a tool so someone can highlight a cell or group of cells and it will search the internet with that string. This is way above my level and don't know where to start? I even tried to search the forums here but nothing like this have I found?
Djblois
08-17-2007, 01:06 PM
Is this even possible?
Ron Coderre
08-17-2007, 01:09 PM
Perhaps something as simple as this in an Excel General Module(for one cell)
Note: Being new to this forum, the editor balked at allowing hyperlinks....so replace the all CAPS words with the obvious(COLON=: DOT=. etc)
Sub GoogleSearch()
Shell "C:\Program Files\Internet Explorer\iexplorer.exe http COLON BACKSLASH BACKSLASH wwwDOTgoogleDOTcoDOTuk/search?hl=en&q=" & ActiveCell, vbMaximizedFocus
End Sub
Select a cell with terms to search for
[Alt]+[F8]....Select "GoogleSearch"....Click [Run]
An Internet Explorer window will open and run a Google search for the term in the active cell
Does that give you something to work with?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.