Home

Getting Started

For existing workbooks, open install.bat and enter the path to the workbook and the installation/upgrade is taken care of for you! (Be sure to add a reference to Microsoft Scripting Runtime: VBA Window, Tools > References > Select 'Microsoft Scripting Runtime')

For new workbooks, Excel-REST - Blank.xlsm has everything setup and ready to go.

That's it! There are many advanced uses for Excel-REST, including asynchronous requests so that Excel isn't locked up, Authenticators for accessing services with Basic, OAuth1, and OAuth2 authentication, and detailed requests for complex APIs.

Components

• RestRequest Create a rich definition of the request, including Resource (URL), Method (GET, POST, etc), Format (json), Headers, Querystring, Body, and more.
• RestClient Execute RestRequests, both sync and async.
• RestResponse Formatted response from RestRequest, including status (200, 404, etc), content, and parsed results.

Examples

• Google Maps
• Twitter
• Salesforce
• Google APIs

See the examples/ folder to see these examples in action

Additional topics

• Debugging
• Authentication
• Implementing your own IAuthenticator