Having Difficulty with Smartsheet API in Excel

I'm looking for examples of calling the Smartsheet API from Excel. I can't seem to get the syntax right.

Answers

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com