{"version":"1.0","provider_name":"Saibam","provider_url":"https:\/\/saibam.com.br\/excel","author_name":"admin","author_url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/","title":"CEPs - Saibam","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"rxM7qP8wbb\"><a href=\"https:\/\/saibam.com.br\/excel\/api-cep-em-vba\/\">CEPs<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/saibam.com.br\/excel\/api-cep-em-vba\/embed\/#?secret=rxM7qP8wbb\" width=\"600\" height=\"338\" title=\"&#8220;CEPs&#8221; &#8212; Saibam\" data-secret=\"rxM7qP8wbb\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/saibam.com.br\/excel\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"Chamar uma API externa para consultar os CEPs de uma cidade usando VBA pode ser realizado atrav\u00e9s de APIs p\u00fablicas dispon\u00edveis. Uma das APIs que voc\u00ea pode usar para este prop\u00f3sito \u00e9 a ViaCEP, que permite consultar informa\u00e7\u00f5es de CEPs no Brasil.","thumbnail_url":"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/11\/API_CEPS-1024x690.png"}