Why a Google Search Utility?
If Google is so good, why do we need a Google Search Add-in? Good question!
1) Google Search puts a search tool where you want it and when you want it.
(Under the Help menu in the menu bar)
2) Google Search provides a user friendly and intuitive interface that provides you with the
Knowledge of how and where to search.
What Does Google Search Do?
1) There is an ability to search newsgroups between user determined dates.
With ever increasing postings to newsgroups month by month it will preserve the key
speed advantage of Google.
2) There is an ability to search the Microsoft Knowledge Base and allow version specific
and Microsoft product specific searches.
3) There is an ability to search in Websites (for example the MSDN, MS Support…. sites).
4) There is an ability to choose a site in your Favorite sites Combobox and open that site.
5) You can add, delete or change the order very easy of the items in the
(Newsgroups, Websites (to search in), Knowledge Base options and Favorite sites)
Version 6 and 7 stores all information in an Access database file instead of in a separate sheet in the Add-in.
This allows me to make an Add-in for other Office programs.
However, you don’t need to have Access installed on your computer. The ADO that is used to
write and read from and to the Access file is installed by default in Office 2000 and higher.
Acknowledgements
I am very grateful that Norman Harker MVP (Excel) wrote this documentation for me.
Be glad I did not create it with my bad English<g>.
I'd also like to thank Excel MVPs Dave Peterson and J.E. McGimpsey for there picky stuff and suggestions.
And a special thanks to Excel MVP Rob Bovey for helping me with the ADO code in the Add-in.
Legal Stuff
This utility is distributed freely and with maximum exclusion of liability permitted by law.
Further distribution is permitted subject to:
1. Such distribution not being directly or indirectly for gain or reward, and 2. Distribution being together with these notes, and 3. Appropriate and prominent attribution to Ron de Bruin.
Copyright on VBA coding and techniques used to create this program is specifically retained.
Use of this program is subject to the restriction that there should be no access to or copying
of the VBA Project that forms part of the workbook without consent of Ron de Bruin and use
of a password provided only by him for that purpose.
Google Search version 7 for Office 2007
To
use the Google Search utility:
1. Download and extract it to a local directory.
2. Copy GoogleSearch.xlam and the Access file to the following directory:
local_drive:\Program Files\Microsoft
Office\Office12\Library
Then click the Microsoft Office button, click Excel Options, click the Add-Ins tab.
In
the Manage drop-down, click Excel Add-ins, and click Go.
Verify Google Search is checked in this list and then click OK.
Download the 2007 version here (Add-in date 1-Jan-2007)
Use this to open the add-in: Office Button>Google Search.
Another way to open the add-in is to use the shortcut Alt FG.
Tip : Right click on the Google Search menu item and choose "Add to Quick Access Toolbar"
This way you can open the add-in with one click.
Google Search version 6 for Office 2000-2003
Download Excel version 6.01 ( Add-in date 19 - Nov - 2004)
Download the Dutch version
Download the German version.
To
use the Google Search utility:
1. Download and extract it to a local directory.
2. Copy GoogleSearch.xla and the Access file to the following directory:
local_drive:\Program Files\Microsoft Office\OfficeNumber\Library
Note Depending on the version of Excel, the OfficeNumber directory may named
Office or may include a version number. For example:
local_drive:\Program Files\Microsoft
Office\Office\Library
-OR-
local_drive:\Program Files\Microsoft
Office\Office11\Library
Once installed, to access it:
3. Start Excel and open a workbook.
4. Click Tools, click Add-Ins, Verify Google Search is checked in
this list and then click OK.
Note Be sure that in Tools>Macro..Security on the “Trusted
Publishers” tab “Trust all installed add-ins and templates” is checked.
You find a Google Search item under the Help menu to open the add-in.
Manual
If you need help please read this Superb manual first.
This is the manual for Excel but 99% is the same for the other programs.
The only thing that is different is loading the Add-in (see note below the download link)
Download the User Guide (Prepared by Norman Harker) Word document
Download the User Guide (Prepared by Norman Harker) PDF document
Word and PowerPoint
Download Word version 6.02 ( Template date 20 - Nov - 2004)
You must copy the Access database file and the template in to the Word Startup folder. You can find that location in Tools>Options ..File locations in the Word menu bar. In Windows XP this is a hidden folder (go to the Control Panel and change the view in the Folder Options)
You find a Google Search item under the Help menu to open the Userform.
Download PowerPoint version 6.01 ( Add-in date 20 - Nov - 2004)
You must copy the Access database file and the Add-in in to the same folder.
Use Tools>Add-ins in the Menu Bar to browse to the Add-in to install it.
You find a Google Search item under the Help menu to open the Userform
Download the German PowerPoint version.
Google Search version 5.2 for Excel 97-2003
You still be able to download this version because: 1) You can also open the Userform in the VBE editor 2) It is also working in Excel 97.
Download the User Guide (Prepared by Norman Harker) Word document
Download the User Guide (Prepared by Norman Harker) PDF document
I made some small changes in 5.2 so the User guide name is still 5.0.
Download the Google Search Add-in (Version 5.2, Add-in date 20-Nov-2004)
Mac Version
Thanks to J.E. McGimpsey for rebuilding version 4.1 for the Mac users.
Download the Mac Add-in in zip format
Download the Mac Add-in in Stuffit format
See also this page for a Beta version
http://mcgimpsey.com/excel/googlesearch.html
If you like this concept of getting what you want where you want it, then you might like the SendMail
tool that I have developed.
This places the ability send copies of selected areas, sheets and entire workbooks from within Excel.
The material sent can be restricted to just sending the ‘naked’ data without formulas or to send it fully operational.
My SendMail tool is available as a free download from:
www.rondebruin.nl/sendmail.htm
Ron de Bruin
Microsoft MVP - Excel