API Tool In Excel

Thanks Ken!

Awesome!
This helps me from having to manually build and run all of my calls from a dev console or browser.
Thanks for sharing!

Is there a way to get the password to unlock the VB script. I think this is cool but I wanted to parse out functions based on roles (I.E. remove some code as needed)

When I am trying to click on Open Quickbase API Form, I get an error message "Compile error in hidden module". Can you please help?

Try this link:

https://www.dropbox.com/s/ebfvyd4ip2cwnup/QB_API.xls?dl=0

https://www.dropbox.com/s/4x7jt5nzx54p5cl/QBDownload.zip?dl=0

Ken

Ken, I successfully downloaded the file and it works fine connecting to App.,  But how could I use this to download data from QB to Excel?

Here's a link to instructions for QBDownload:

https://www.dropbox.com/s/tut64bdyoxjndnq/QBDownLoad%20Instructions.docx?dl=0

Thanks Ken. I have macros enabled.  Yet I am getting VB error  Runt-ime error '91': Object variable or With block variable not set.  This error occurs after adding my domain and password and trying to authenticate.  Could you kindly help?

Hi Ken, Thanks for the excellent tool.  Just wonder how to use existing Workbook option. This is badly needed as Filemaker cannot read XLSM files, and process needs to be automated to convert XLSM to XLSX or use existing Workbook option (If you can open Macros, then can adjust it myself and pass it to you).  Kind regards

Hi Ken,

I am trying to use this tool to write a macro that pulls from one specific table into Excel repeatedly. Is there any way you can write/point me in the right direction so I can write such a macro? Thank you in advance.

Best,
Gaurav