msgpack decode in VBA

I'll post some work in progress in the morning when I'm back at work

Awesome, thanks Kyle!

Ok, this works (with limited testing anyway), it will accept a provided encoded byte array and parse to a Json object or string. I haven't managed to encode and decode a string in VBA - I can encode and return the hex representation - but I haven't sussed a way out of returning it in a way that will allow decoding. I'll have a fiddle when I get chance.

There are a couple of steps, the code I used is here: https://github.com/mcollina/msgpack5, specifically https://github.com/mcollina/msgpack5...sgpack5.min.js.

Grab a copy of it and save it somewhere.

It won't run as is due to the Script Control not actually being JavaScript in the conventional sense and the implementation being quite old. So you then need to add polyfills to the Javascript to make up for missing features in the implementation.

Go to your saved js file and copy and paste the code below above the msgpack code:

Please Login or Register  to view this content.

Then you should be able to run the following (changing the path to suit):

Please Login or Register  to view this content.

To speak with Macklemore: This is f'ing awesome!

Does it work? In the absence of suitable messagepack I was just testing with simple strings and objects

Testing it later today. A bit busy with some devices at work