Forgive me if this has been asked, but is there a way to use the Halo API through VBA via Microsoft Excel (or something similar)? I am trying to pull in data and work with it in a spreadsheet, nothing fancy, but I can’t seem to figure out how to pull in the data (if it is even possible). Does anyone have any insight?
I’ve never used VBA, but a quick search on stack overflow suggests it’s possible…
You might have some luck using the add-on “Power Query” to get the data into your spreadsheet, then using VBA to manipulate it from there.
http://www.excel2013.info/power-query/connection-api/
I’d recommend at least Excel 2013, (it has an internal object model, which 2007 and 2010 don’t, meaning better performance) and a 64 bit installation, or you’ll be capped at 4GB of memory, which will limit what you can do.
There was another thread on this here.
I posted a little how-to-guide to get up and running there as well.