You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to excel-r...@googlegroups.com
First thanks a lot for the JSON implementation in Excel. I sucessfully conect to my web-service and parse the JSON string into VBA.
I did a lot with looping thru the arrays but now I wonder if there is a possibilty to check if a child exsist ?
for example in the array family the sub array kids only show up if there are kids. so looping the family array and have a short statment like if jo.child("kids").exsist = true then
I tried but failed. Any suggestion how to address this. Looping thru all keys with a big select Case statement I don't like.
Bruce Mcpherson
unread,
Jan 24, 2013, 12:45:15 PM1/24/13
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to excel-r...@googlegroups.com
Not sure if you mean any children or a specific child .. here's both
if not jo.childExists("somename") is nothing then
--
Bruce Mcpherson
unread,
Jan 24, 2013, 12:46:34 PM1/24/13
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to excel-r...@googlegroups.com
On 24 January 2013 17:45, Bruce Mcpherson <br...@mcpher.com> wrote:
Not sure if you mean any children or a specific child .. here's both
if not jo.childExists("somename") is nothing then
it exists....
or
if jo.hasChildren then
.. there are children
bruce
Stephan Streck
unread,
Jan 24, 2013, 2:29:22 PM1/24/13
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to excel-r...@googlegroups.com
Perfect.
Exactly the the "if not ... is nothing" statement I was looking for.