Adding / Manipulating / Clearing Borders in Excel with AutoHotkey

Borders in ExcelIn this tutorial I show how to add / remove / edit Borders in Excel with AutoHotkey.   Below is the code I use to apply the changes.  Be sure to review this if you’re unfamiliar with connecting to Excel via a COM object,

Function for working with Borders in Excel

Here is the video where I walk through using the function to play with Borders in Excel

Excel & AutoHotkey-Adding & Removing Borders

Example Webservice / API call- 4 GoogleMaps API services

In the following video I work through connecting for four separate APIs which are all under GoogleMaps.  It is very easy to connect to them with AutoHotkey.  Simply get your own token and then adapt the below code to your needs!

Video reviewing the four GoogleMaps APIs.

GoogleMaps Directions API

GoogleMaps GeoCode API

GoogleMaps Places

GoogleMaps TimeZone

 

Example Webservice / API call- Connecting to Zoom & extracting info

For the the AutoHotkey Webinars we use Zoom which is a great, robust, inexpensive tool for hosting online meetings/webinars.  They have a free version which allows you to connect with people for up to 45 minutes!

Below I walk through the following code where I demonstrate how I extract information about users & their meetings.   This is a great example of how many vendors offer APIs to connect to their tools.

Video walking through developing the Zoom API call

Example Webservice / API call- Connecting to Zoom & extracting info

Example Webservice / API call- Zillow -Get deep search results

In this review we follow-up on our API webinar showing how to access Real estate / home values through the Zillow API.  Here is the code I walk through in the below video.   This API is pretty straight-foward and easy to use.  It can be a lot of fun to see what your home, and your neighbor’s is worth!

 

Video walking through the API code