I was able to get my Google Voice number last week. It is wonderful to be able to make free US and Canada calls with GV. The only downside being you have to first login to your GV account to use their dialer or select a contact from your Google Contacts address book. I thought it would be nice if I could dial a contact right from a spreadsheet on my PC desktop without first logging into my GV account.
To do that I created a Microsoft Excel spreadsheet which can store all my contacts. I wrote Excel VB macros to do the login and dialing using my GV account. Double clicking on any cell that contains a phone number would dial that number using my GV account.
You may download the spreadsheet from the link below. You have to have macros enabled in Excel to make use of this spreadsheet. First time you open the spreadsheet you will be prompted to enter your GV user id and password which will be stored in hidden cells for future use. So be careful not to share this spreadsheet with others. In case you don’t want to store your credentials in the spreadsheet, before you save the spreadsheet you can click the ‘Clear Credentials’ button which will clear your user id and password.
http://infinilogix.com/downloads/Contacts.xls
Disclaimer: The spreadsheet is provided as is without any warranty about its usability or performance. It has only been tested using MS Excel 2003 though it should work with other versions too. But I cannot guarantee that.
Recent Comments