PDA

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?