In PHP, there is the function json_encode which does this.
In the code, it's a one-liner:
Is there a built-in equivalent in Excel VBA? Or do we have to do it manually?PHP Code:
$encoded = json_encode($myobj); //Badabing! And you're done.
In PHP, there is the function json_encode which does this.
In the code, it's a one-liner:
Is there a built-in equivalent in Excel VBA? Or do we have to do it manually?PHP Code:
$encoded = json_encode($myobj); //Badabing! And you're done.
I am not very clear about your mean.
See if this is useful to you:
Please Login or Register to view this content.
No, though there are some libraries out there that may be able to help, have a google for Bruce McPhearson - Excel Ramblings
Thanks Kyle, I came to that conclusion. I have written a couple of classes to do it, it turns out not to require a particularly complex or bloated class, if you are happy to ignore character encodings. Shame there is no built-in like PHP. (Shame there are not LOTS of things in VBA that PHP provides, for that matter!)
Yeah but Excel isn't really designed for web stuff and VB6 has been dead as a dodo for yonks - besides, PHP is nasty gimme C# any day
Ah! I don't know C#, but I like PHP because I'm a penguin, not a window, or a dodo
A penguin running Excel - that sounds nasty, you using Wine? How does it perform?
No, I have a win machine and a linux machine!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks