{"id":1890,"date":"2023-10-29T19:00:16","date_gmt":"2023-10-29T19:00:16","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/ricerca-google\/"},"modified":"2023-12-10T06:21:41","modified_gmt":"2023-12-10T06:21:41","slug":"ricerca-google","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/ricerca-google\/","title":{"rendered":"Come cercare su google utilizzando vba?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-255300432\"><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>Ci sono molte cose importanti che facciamo tutti oltre all&#8217;utilizzo di Excel. Ho ragione?<\/p><p> Una di queste cose \u00e8 usare Google per cercare qualcosa. Nel mio elenco di codici macro utili, ho un codice che puoi utilizzare per eseguire una query di ricerca su Google utilizzando Chrome.<\/p><p> E oggi condivider\u00f2 questo codice con te. Puoi aggiungere questo codice alla tua <a href=\"https:\/\/exceladvisor.org\/it\/quaderno-macro-personale\/\" target=\"_blank\" rel=\"noopener noreferrer\">cartella di lavoro macro personale<\/a> e utilizzarlo ogni volta che hai bisogno di qualcosa su Google.<\/p><h2 class=\"wp-block-heading\"> Codice VBA per aprire Google Chrome per la ricerca<\/h2><p> Ecco il codice seguente che puoi utilizzare per cercare su Google utilizzando Chrome.<\/p><h3 class=\"wp-block-heading\"> Versione Windows 32<\/h3><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><h3 class=\"wp-block-heading\"> Versione per Windows 64<\/h3><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><h2 class=\"wp-block-heading\"> Come utilizzare questo codice VBA per effettuare ricerche su Google<\/h2><p> Ecco il semplice passaggio che devi seguire per riscattare questo codice.<\/p><ul><li> Apri l&#8217;editor VB utilizzando il tasto di scelta rapida Alt + F11 o vai alla scheda sviluppatore. <\/li><\/ul><div class=\"wp-block-image\"><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><\/div><ul><li> Inserisci un nuovo modulo e incolla al suo interno il codice sopra. <\/li><\/ul><div class=\"wp-block-image\"><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><\/div><p> Ora chiudi l&#8217;editor VB ed esegui questa macro dall&#8217;opzione macro nella scheda sviluppatore.<\/p><h3 class=\"wp-block-heading\"> Come funziona<\/h3><p> Quando esegui questo codice, ti viene mostrata una casella di input per inserire la tua query. E devi inserire la tua query in questa casella di input e fare clic su OK. <\/p><div class=\"wp-block-image\"><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><\/div><p> Dopo aver fatto clic su OK, questo codice crea la sintassi dell&#8217;URL di ricerca utilizzando il testo immesso. <\/p><div class=\"wp-block-image\"><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><\/div><p> E, alla fine, reindirizza Chrome a questo URL per fornirti i risultati per la query che hai inserito.<\/p><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\/it\/vba\/\">Cos&#8217;\u00e8 VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial correlati <\/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\/it\/evidenziare-i-valori-duplicati\/\">Evidenzia i valori duplicati utilizzando VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/estrarre-il-collegamento-ipertestuale\/\">Estrai l&#8217;indirizzo del collegamento ipertestuale (URL) VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/campo-di-immissione\/\">Casella di input in VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/file-di-testo\/\">VBA crea e scrive in un file di testo<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/aggiornamento-dello-schermo\/\">Aggiornamento schermata 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-1890","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>Come cercare su Google utilizzando VBA?<\/title>\n<meta name=\"description\" content=\"Ho del codice che puoi utilizzare per eseguire una query di ricerca su Google utilizzando Chrome. E oggi condivider\u00f2\" \/>\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\/it\/ricerca-google\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come cercare su Google utilizzando VBA?\" \/>\n<meta property=\"og:description\" content=\"Ho del codice che puoi utilizzare per eseguire una query di ricerca su Google utilizzando Chrome. E oggi condivider\u00f2\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/ricerca-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:21: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=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/ricerca-google\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/ricerca-google\/\",\"name\":\"Come cercare su Google utilizzando VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/ricerca-google\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/ricerca-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-10T06:21:41+00:00\",\"description\":\"Ho del codice che puoi utilizzare per eseguire una query di ricerca su Google utilizzando Chrome. E oggi condivider\u00f2\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/ricerca-google\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/ricerca-google\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/ricerca-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\/it\/ricerca-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come cercare su google utilizzando vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come cercare su Google utilizzando VBA?","description":"Ho del codice che puoi utilizzare per eseguire una query di ricerca su Google utilizzando Chrome. E oggi condivider\u00f2","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\/it\/ricerca-google\/","og_locale":"it_IT","og_type":"article","og_title":"Come cercare su Google utilizzando VBA?","og_description":"Ho del codice che puoi utilizzare per eseguire una query di ricerca su Google utilizzando Chrome. E oggi condivider\u00f2","og_url":"https:\/\/exceladvisor.org\/it\/ricerca-google\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:21: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":{"Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/ricerca-google\/","url":"https:\/\/exceladvisor.org\/it\/ricerca-google\/","name":"Come cercare su Google utilizzando VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/ricerca-google\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/ricerca-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-10T06:21:41+00:00","description":"Ho del codice che puoi utilizzare per eseguire una query di ricerca su Google utilizzando Chrome. E oggi condivider\u00f2","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/ricerca-google\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/ricerca-google\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/ricerca-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\/it\/ricerca-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come cercare su google utilizzando vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=1890"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1890\/revisions"}],"predecessor-version":[{"id":2375,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1890\/revisions\/2375"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=1890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}