{"id":418,"date":"2023-10-29T18:40:55","date_gmt":"2023-10-29T18:40:55","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/"},"modified":"2023-12-06T11:37:43","modified_gmt":"2023-12-06T11:37:43","slug":"extrair-hiperlink","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/","title":{"rendered":"Como extrair endere\u00e7os da web no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-776184492\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><div class=\"excel-before-content\" id=\"excel-3317174949\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p class=\"has-text-align-left\">Suponha que voc\u00ea receba uma pasta de trabalho do Excel de seu colega na qual voc\u00ea tem uma lista de hiperlinks em uma coluna. Agora, desta lista, voc\u00ea deseja extrair todos os URLs do hiperlink.<\/p><p> O m\u00e9todo manual \u00e9 uma verdadeira dor de cabe\u00e7a, voc\u00ea tem que copiar e colar cada URL um por um. Ent\u00e3o a melhor forma \u00e9 <a href=\"https:\/\/exceladvisor.org\/pt\/funcao-definida-pelo-usuario-2\/\" data-wpel-link=\"internal\">criar uma UDF em VBA<\/a> . E hoje gostaria de compartilhar com voc\u00eas um c\u00f3digo simples para esta UDF.<\/p><h2 class=\"wp-block-heading\"> C\u00f3digo VBA para extrair URLs de hiperlink<\/h2><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Function GiveMeURL(rng As Range) As String On Error Resume Next GiveMeURL = rng.Hyperlinks(1).Address End Function<\/code><\/pre><h2 class=\"wp-block-heading\"> Como usar este c\u00f3digo<\/h2><p> Para usar esta UDF, voc\u00ea deve seguir estas etapas:<\/p><ol><li> Abra o Editor do Visual Basic na guia Desenvolvedor ou use o atalho de teclado ALT+F11.<\/li><li> Insira um novo m\u00f3dulo, cole o c\u00f3digo acima nele e feche-o.<\/li><li> Agora, em sua planilha, insira a fun\u00e7\u00e3o <strong><mark class=\"has-inline-color\" style=\"background-color: #f5e053;\">=GiveMeURL(A1)<\/mark><\/strong> e pressione Enter.<\/li><\/ol><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/pt\/vba\/\">O que \u00e9 VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriais relacionados <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/destacar-valores-duplicados\/\">Destaque valores duplicados usando VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/campo-de-entrada\/\">Caixa de entrada em VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/arquivos-de-texto\/\">VBA cria e grava em um arquivo de texto<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/atualizacao-de-tela\/\">Atualiza\u00e7\u00e3o de tela VBA<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-418","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como extrair endere\u00e7os da web no Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Suponha que voc\u00ea recebeu uma pasta de trabalho de seu colega na qual possui uma lista de hiperlinks e deseja\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como extrair endere\u00e7os da web no Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Suponha que voc\u00ea recebeu uma pasta de trabalho de seu colega na qual possui uma lista de hiperlinks e deseja\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:37:43+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/\",\"name\":\"Como extrair endere\u00e7os da web no Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"datePublished\":\"2023-10-29T18:40:55+00:00\",\"dateModified\":\"2023-12-06T11:37:43+00:00\",\"description\":\"Suponha que voc\u00ea recebeu uma pasta de trabalho de seu colega na qual possui uma lista de hiperlinks e deseja\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como extrair endere\u00e7os da web no excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como extrair endere\u00e7os da web no Excel? (Tutorial 2023)","description":"Suponha que voc\u00ea recebeu uma pasta de trabalho de seu colega na qual possui uma lista de hiperlinks e deseja","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:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/","og_locale":"pt_PT","og_type":"article","og_title":"Como extrair endere\u00e7os da web no Excel? (Tutorial 2023)","og_description":"Suponha que voc\u00ea recebeu uma pasta de trabalho de seu colega na qual possui uma lista de hiperlinks e deseja","og_url":"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:37:43+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/","url":"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/","name":"Como extrair endere\u00e7os da web no Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"datePublished":"2023-10-29T18:40:55+00:00","dateModified":"2023-12-06T11:37:43+00:00","description":"Suponha que voc\u00ea recebeu uma pasta de trabalho de seu colega na qual possui uma lista de hiperlinks e deseja","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/extrair-hiperlink\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como extrair endere\u00e7os da web no excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=418"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/418\/revisions"}],"predecessor-version":[{"id":1062,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/418\/revisions\/1062"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}