{"id":1204,"date":"2015-09-24T18:08:51","date_gmt":"2015-09-24T18:08:51","guid":{"rendered":"http:\/\/elbsolutions.com\/projects\/?p=1204"},"modified":"2022-02-03T11:24:36","modified_gmt":"2022-02-03T17:24:36","slug":"fw-vba-and-json-is-it-worth-it-xml-vs-json","status":"publish","type":"post","link":"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/","title":{"rendered":"FW: VBA and JSON &#8211; is it worth it? XML vs JSON"},"content":{"rendered":"<p>It seems we have to turn on a reference to a Library of some sort. XML is a standard that works and is established. I am obsessed with Dictionaries so I always have to reference c:WindowsSystem32scrrun.dll (Microsoft Scripting Library). Over the years, updates etc are different from computer to computer \u2013 so the question is \u2013 Angular etc. use JSON services which are SOOOO easy to generate \u2013 but is VBA keeping up? It might. Lets take a look at some research \u00b7<\/p>\n<ul>\n<li><a href=\"http:\/\/www.mrexcel.com\/forum\/excel-questions\/640780-parse-json-excel-visual-basic-applications.html\" target=\"_blank\" rel=\"noopener noreferrer\">These guys are happy: See Juan\u2019s solution<\/a><\/li>\n<li><a href=\"http:\/\/stackoverflow.com\/questions\/19360440\/how-to-parse-json-with-vba-without-external-libraries\" target=\"_blank\" rel=\"noopener noreferrer\">A few happy customers here \u2013 3 main options<\/a>\n<ul>\n<li><a href=\"http:\/\/stackoverflow.com\/questions\/16817545\/handle-json-object-in-xmlhttp-response-in-excel-vba-code\/16851758#16851758\" target=\"_blank\" rel=\"noopener noreferrer\">Since the above was tagged a duplicate, these ones worked too<\/a> (and it uses Dictionaries! Ok \u2013perhaps I am biased)<\/li>\n<li>\u00a0Also the above link has some teaching links which I find interesting. They do more than JSON.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>It seems we have to turn on a reference to a Library of some sort. XML is a standard that works and is established. I am obsessed with Dictionaries so I always have to reference c:WindowsSystem32scrrun.dll (Microsoft Scripting Library). Over the years, updates etc are different from computer to computer \u2013 so the question is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,12,13],"tags":[],"class_list":["post-1204","post","type-post","status-publish","format-standard","hentry","category-general","category-scripting","category-web-integration"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>FW: VBA and JSON - is it worth it? XML vs JSON - ELB Solutions.com Inc.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FW: VBA and JSON - is it worth it? XML vs JSON - ELB Solutions.com Inc.\" \/>\n<meta property=\"og:description\" content=\"It seems we have to turn on a reference to a Library of some sort. XML is a standard that works and is established. I am obsessed with Dictionaries so I always have to reference c:WindowsSystem32scrrun.dll (Microsoft Scripting Library). Over the years, updates etc are different from computer to computer \u2013 so the question is [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/\" \/>\n<meta property=\"og:site_name\" content=\"ELB Solutions.com Inc.\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-24T18:08:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-03T17:24:36+00:00\" \/>\n<meta name=\"author\" content=\"Etienne Bley\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Etienne Bley\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/fw-vba-and-json-is-it-worth-it-xml-vs-json\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/fw-vba-and-json-is-it-worth-it-xml-vs-json\\\/\"},\"author\":{\"name\":\"Etienne Bley\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"headline\":\"FW: VBA and JSON &#8211; is it worth it? XML vs JSON\",\"datePublished\":\"2015-09-24T18:08:51+00:00\",\"dateModified\":\"2022-02-03T17:24:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/fw-vba-and-json-is-it-worth-it-xml-vs-json\\\/\"},\"wordCount\":146,\"articleSection\":[\"General\",\"Scripting\",\"Web Integration\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/fw-vba-and-json-is-it-worth-it-xml-vs-json\\\/\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/fw-vba-and-json-is-it-worth-it-xml-vs-json\\\/\",\"name\":\"FW: VBA and JSON - is it worth it? XML vs JSON - ELB Solutions.com Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\"},\"datePublished\":\"2015-09-24T18:08:51+00:00\",\"dateModified\":\"2022-02-03T17:24:36+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/fw-vba-and-json-is-it-worth-it-xml-vs-json\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/fw-vba-and-json-is-it-worth-it-xml-vs-json\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/fw-vba-and-json-is-it-worth-it-xml-vs-json\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FW: VBA and JSON &#8211; is it worth it? XML vs JSON\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\",\"name\":\"ELB Solutions.com Inc.\",\"description\":\"Bringing all your IT Pieces together\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\",\"name\":\"Etienne Bley\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"caption\":\"Etienne Bley\"},\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/author\\\/etienne-bley\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"FW: VBA and JSON - is it worth it? XML vs JSON - ELB Solutions.com Inc.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/","og_locale":"en_US","og_type":"article","og_title":"FW: VBA and JSON - is it worth it? XML vs JSON - ELB Solutions.com Inc.","og_description":"It seems we have to turn on a reference to a Library of some sort. XML is a standard that works and is established. I am obsessed with Dictionaries so I always have to reference c:WindowsSystem32scrrun.dll (Microsoft Scripting Library). Over the years, updates etc are different from computer to computer \u2013 so the question is [&hellip;]","og_url":"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/","og_site_name":"ELB Solutions.com Inc.","article_published_time":"2015-09-24T18:08:51+00:00","article_modified_time":"2022-02-03T17:24:36+00:00","author":"Etienne Bley","twitter_misc":{"Written by":"Etienne Bley","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/#article","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/"},"author":{"name":"Etienne Bley","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"headline":"FW: VBA and JSON &#8211; is it worth it? XML vs JSON","datePublished":"2015-09-24T18:08:51+00:00","dateModified":"2022-02-03T17:24:36+00:00","mainEntityOfPage":{"@id":"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/"},"wordCount":146,"articleSection":["General","Scripting","Web Integration"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/","url":"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/","name":"FW: VBA and JSON - is it worth it? XML vs JSON - ELB Solutions.com Inc.","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/#website"},"datePublished":"2015-09-24T18:08:51+00:00","dateModified":"2022-02-03T17:24:36+00:00","author":{"@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"breadcrumb":{"@id":"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/elbsolutions.com\/projects\/fw-vba-and-json-is-it-worth-it-xml-vs-json\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/elbsolutions.com\/projects\/"},{"@type":"ListItem","position":2,"name":"FW: VBA and JSON &#8211; is it worth it? XML vs JSON"}]},{"@type":"WebSite","@id":"https:\/\/elbsolutions.com\/projects\/#website","url":"https:\/\/elbsolutions.com\/projects\/","name":"ELB Solutions.com Inc.","description":"Bringing all your IT Pieces together","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/elbsolutions.com\/projects\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39","name":"Etienne Bley","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","caption":"Etienne Bley"},"url":"https:\/\/elbsolutions.com\/projects\/author\/etienne-bley\/"}]}},"_links":{"self":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/comments?post=1204"}],"version-history":[{"count":2,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1204\/revisions"}],"predecessor-version":[{"id":2731,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1204\/revisions\/2731"}],"wp:attachment":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/media?parent=1204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/categories?post=1204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/tags?post=1204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}