{"id":418,"date":"2023-10-29T19:00:16","date_gmt":"2023-10-29T19:00:16","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/"},"modified":"2023-12-25T10:23:41","modified_gmt":"2023-12-25T10:23:41","slug":"busqueda-de-google","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/","title":{"rendered":"\u00bfc\u00f3mo buscar en google usando vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-335587577\"><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>Hay muchas cosas importantes que todos hacemos adem\u00e1s de usar Excel. \u00bfEstoy en lo cierto?<\/p>\n<p> Una de esas cosas es usar Google para buscar algo. En mi lista de c\u00f3digos de macro \u00fatiles, tengo un c\u00f3digo que puedes usar para realizar una consulta de b\u00fasqueda en Google usando Chrome.<\/p>\n<p> Y hoy compartir\u00e9 este c\u00f3digo contigo. Puede agregar este c\u00f3digo a su <a href=\"https:\/\/exceladvisor.org\/es\/cuaderno-macro-personal\/\" target=\"_blank\" rel=\"noopener noreferrer\">libro de macros personal<\/a> y usarlo cada vez que necesite buscar algo en Google.<\/p>\n<h2 class=\"wp-block-heading\"> C\u00f3digo VBA para abrir Google Chrome para realizar b\u00fasquedas<\/h2>\n<p> Aqu\u00ed est\u00e1 el c\u00f3digo a continuaci\u00f3n que puede usar para buscar en Google usando Chrome.<\/p>\n<h3 class=\"wp-block-heading\"> versi\u00f3n windows 32<\/h3>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub Google_Search_32() Dim chromePath As String Dim search_string As String Dim query As String query = InputBox(\"Enter here your search here\", \"Google Search\") search_string = query search_string = Replace(search_string, \" \", \"+\") chromePath = \"\"\"C:\\Program Files (x86)\\Google\\Chrome\\Application\\chrome.exe\"\"\" Shell (chromePath &amp; \" -url http:\/\/google.com\/search?q=\" &amp; search_string) End Sub<\/code><\/pre>\n<h3 class=\"wp-block-heading\"> versi\u00f3n windows 64<\/h3>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub Google_Search_64() Dim chromePath As String Dim search_string As String Dim query As String query = InputBox(\"Enter here your search here\", \"Google Search\") search_string = Replace(query, \" \", \"+\") chromePath = \"\"\"C:\\Program Files\\Google\\Chrome\\Application\\chrome.exe\"\"\" Shell (chromePath &amp; \" -url http:\/\/google.com\/search?q=\" &amp; search_string) End Sub<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> C\u00f3mo utilizar este c\u00f3digo VBA para buscar en Google<\/h2>\n<p> Este es el paso simple que debes seguir para canjear este c\u00f3digo.<\/p>\n<ul>\n<li> Abra el editor VB usando la tecla de acceso directo Alt + F11 o vaya a la pesta\u00f1a de desarrollador. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-lediteur-vb-pour-coller-le-code-vba-pour-ouvrir-google-chrome-pour-rechercher-min.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure>\n<\/div>\n<ul>\n<li> Inserte un nuevo m\u00f3dulo y pegue el c\u00f3digo anterior en \u00e9l. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/coller-le-code-vba-dans-lediteur-vb-pour-ouvrir-google-chrome-pour-rechercher-min.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure>\n<\/div>\n<p> Ahora cierre el editor VB y ejecute esta macro desde la opci\u00f3n de macros en la pesta\u00f1a de desarrollador.<\/p>\n<h3 class=\"wp-block-heading\"> C\u00f3mo funciona<\/h3>\n<p> Cuando ejecuta este c\u00f3digo, le muestra un cuadro de entrada para ingresar su consulta. Y debe ingresar su consulta en este cuadro de entrada y hacer clic en Aceptar. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/executer-la-macro-ouvrir-google-chrome-pour-rechercher-min.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure>\n<\/div>\n<p> Despu\u00e9s de hacer clic en Aceptar, este c\u00f3digo crea la sintaxis de la URL de b\u00fasqueda utilizando el texto que ingres\u00f3. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/url-ouvrir-google-chrome-pour-rechercher-min.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure>\n<\/div>\n<p> Y, al final, redirige Chrome a esta URL para brindarle resultados para la consulta que ingres\u00f3.<\/p>\n<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\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/resaltar-valores-duplicados\/\">Resalte valores duplicados usando VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/\">Extraer direcci\u00f3n de hiperv\u00ednculo (URL) VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/campo-de-entrada\/\">Cuadro de entrada en VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/archivos-de-texto\/\">VBA crea y escribe en un archivo de texto<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/\">Actualizaci\u00f3n de pantalla VBA<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-50067b57\">\n<div class=\"gb-container gb-container-50067b57\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Hay muchas cosas importantes que todos hacemos adem\u00e1s de usar Excel. \u00bfEstoy en lo cierto? Una de esas cosas es usar Google para buscar algo. En mi lista de c\u00f3digos de macro \u00fatiles, tengo un c\u00f3digo que puedes usar para realizar una consulta de b\u00fasqueda en Google usando Chrome. Y hoy compartir\u00e9 este c\u00f3digo contigo. [&hellip;]<\/p>\n","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>\u00bfc\u00f3mo buscar en google usando vba?<\/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:\/\/exceladvisor.org\/es\/busqueda-de-google\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo buscar en google usando vba?\" \/>\n<meta property=\"og:description\" content=\"Hay muchas cosas importantes que todos hacemos adem\u00e1s de usar Excel. \u00bfEstoy en lo cierto? Una de esas cosas es usar Google para buscar algo. En mi lista de c\u00f3digos de macro \u00fatiles, tengo un c\u00f3digo que puedes usar para realizar una consulta de b\u00fasqueda en Google usando Chrome. Y hoy compartir\u00e9 este c\u00f3digo contigo. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-lediteur-vb-pour-coller-le-code-vba-pour-ouvrir-google-chrome-pour-rechercher-min.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/\",\"name\":\"\u00bfc\u00f3mo buscar en google usando vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-lediteur-vb-pour-coller-le-code-vba-pour-ouvrir-google-chrome-pour-rechercher-min.png\",\"datePublished\":\"2023-10-29T19:00:16+00:00\",\"dateModified\":\"2023-12-25T10:23:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-lediteur-vb-pour-coller-le-code-vba-pour-ouvrir-google-chrome-pour-rechercher-min.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-lediteur-vb-pour-coller-le-code-vba-pour-ouvrir-google-chrome-pour-rechercher-min.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo buscar en google usando vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo buscar en google usando vba?","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\/es\/busqueda-de-google\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo buscar en google usando vba?","og_description":"Hay muchas cosas importantes que todos hacemos adem\u00e1s de usar Excel. \u00bfEstoy en lo cierto? Una de esas cosas es usar Google para buscar algo. En mi lista de c\u00f3digos de macro \u00fatiles, tengo un c\u00f3digo que puedes usar para realizar una consulta de b\u00fasqueda en Google usando Chrome. Y hoy compartir\u00e9 este c\u00f3digo contigo. [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:41+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-lediteur-vb-pour-coller-le-code-vba-pour-ouvrir-google-chrome-pour-rechercher-min.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/","url":"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/","name":"\u00bfc\u00f3mo buscar en google usando vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-lediteur-vb-pour-coller-le-code-vba-pour-ouvrir-google-chrome-pour-rechercher-min.png","datePublished":"2023-10-29T19:00:16+00:00","dateModified":"2023-12-25T10:23:41+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/busqueda-de-google\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-lediteur-vb-pour-coller-le-code-vba-pour-ouvrir-google-chrome-pour-rechercher-min.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-lediteur-vb-pour-coller-le-code-vba-pour-ouvrir-google-chrome-pour-rechercher-min.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/busqueda-de-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo buscar en google usando vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=418"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/418\/revisions"}],"predecessor-version":[{"id":865,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/418\/revisions\/865"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}