{"id":3018,"date":"2019-03-25T17:42:18","date_gmt":"2019-03-25T20:42:18","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/utilizando-a-funcao-execute-do-vbscript\/"},"modified":"2021-08-09T14:35:42","modified_gmt":"2021-08-09T17:35:42","slug":"utilizando-a-funcao-execute-do-vbscript","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/utilizando-a-funcao-execute-do-vbscript\/","title":{"rendered":"Utilizando a fun\u00e7\u00e3o Execute do VBScript."},"content":{"rendered":"<div align=\"justify\">\n<p><b>Descri\u00e7\u00e3o:<\/b><\/p>\n<p>Pra que serve a fun\u00e7\u00e3o <i>Execute <\/i>do VBScript? Como posso utiliz\u00e1-la?<\/p>\n<p><b>Solu\u00e7\u00e3o:<\/b><\/p>\n<p>A fun\u00e7\u00e3o <i>Execute <\/i>interpreta uma string como uma instru\u00e7\u00e3o do VBScript e a executa no contexto atual. Ela \u00e9 \u00fatil para fazer scripts de verifica\u00e7\u00e3o ou atribui\u00e7\u00e3o de valores de propriedades que tenham nomes sequenciais. Por exemplo, os valores s\u00e3o normalmente atribu\u00eddos em propriedades da seguinte forma:<\/p>\n<pre><span style=\"font-family: Courier New\">Application.GetObject(\"Dados.XObject1\").Propriedade1 = 0<\/span><\/pre>\n<p>Entretanto, quando \u00e9 necess\u00e1rio alterar o valor de um grupo muito grande de propriedades, pode-se utilizar a fun\u00e7\u00e3o <i>Execute<\/i>. Os dois exemplos mostrados abaixo executam a mesma a\u00e7\u00e3o, mas ser\u00e1 poss\u00edvel entender melhor a diferen\u00e7a entre utilizar a atribui\u00e7\u00e3o simples e a atribui\u00e7\u00e3o atrav\u00e9s do m\u00e9todo <i>Execute<\/i>.<\/p>\n<p><u><b>Atribui\u00e7\u00e3o simples<\/b><\/u><\/p>\n<pre><span style=\"font-family: Courier New\">Application.GetObject(\"Dados.XObject1\").Propriedade1 = 1<\/span>\r\n<span style=\"font-family: Courier New\">Application.GetObject(\"Dados.XObject1\").Propriedade2 = 1 <\/span>\r\n<span style=\"font-family: Courier New\">Application.GetObject(\"Dados.XObject1\").Propriedade3 = 0<\/span>\r\n<span style=\"font-family: Courier New\">...<\/span>\r\n<span style=\"font-family: Courier New\">Application.GetObject(\"Dados.XObject1\").Propriedade200 = 0<\/span><\/pre>\n<p><u><b>Atribui\u00e7\u00e3o utilizando a fun\u00e7\u00e3o <i>Execute<\/i><\/b><\/u><\/p>\n<pre><span style=\"font-family: Courier New\">Set obj = Application.GetObject(\"Dados.XObject1\")<\/span>\r\n<span style=\"font-family: Courier New\">For i=1 to 200<\/span>\r\n<span style=\"font-family: Courier New\">\u00a0\u00a0 Execute \"obj.Propriedade\" & CStr(i) & \" = 1 \"<\/span>\r\n<span style=\"font-family: Courier New\">Next<\/span><\/pre>\n<p>Note que a utiliza\u00e7\u00e3o da fun\u00e7\u00e3o <i>Execute <\/i>no script faz com que ele fique menor, o que facilita sua eventual manuten\u00e7\u00e3o\/depura\u00e7\u00e3o.<\/p>\n<p>A aplica\u00e7\u00e3o exemplo anexada a este artigo demonstra a fun\u00e7\u00e3o <i>Execute <\/i>alterando o valor de propriedades de um XObject.<\/p>\n<h3>Anexos:<\/h3>\n<p><a href=\"\/wp-content\/uploads\/2019\/03\/Execute.zip\">Execute.zip<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Descri\u00e7\u00e3o: Pra que serve a fun\u00e7\u00e3o Execute do VBScript? Como posso utiliz\u00e1-la? Solu\u00e7\u00e3o: A fun\u00e7\u00e3o Execute interpreta uma string como uma instru\u00e7\u00e3o do VBScript e a executa no contexto atual.&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[578,610],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Utilizando a fun\u00e7\u00e3o Execute do VBScript. - Elipse Knowledgebase<\/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:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Utilizando a fun\u00e7\u00e3o Execute do VBScript.\" \/>\n<meta property=\"og:description\" content=\"Descri\u00e7\u00e3o: Pra que serve a fun\u00e7\u00e3o Execute do VBScript? Como posso utiliz\u00e1-la? Solu\u00e7\u00e3o: A fun\u00e7\u00e3o Execute interpreta uma string como uma instru\u00e7\u00e3o do VBScript e a executa no contexto atual.&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:42:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-09T17:35:42+00:00\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\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:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"Utilizando a fun\u00e7\u00e3o Execute do VBScript.\",\"datePublished\":\"2019-03-25T20:42:18+00:00\",\"dateModified\":\"2021-08-09T17:35:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/\"},\"wordCount\":193,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"Elipse E3\",\"Scripts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/\",\"url\":\"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/\",\"name\":\"[:pt]Utilizando a fun\u00e7\u00e3o Execute do VBScript.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:42:18+00:00\",\"dateModified\":\"2021-08-09T17:35:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Utilizando a fun\u00e7\u00e3o Execute do VBScript.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Utilizando a fun\u00e7\u00e3o Execute do VBScript. - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]Utilizando a fun\u00e7\u00e3o Execute do VBScript.[:] - Elipse Knowledgebase","og_description":"Descri\u00e7\u00e3o: Pra que serve a fun\u00e7\u00e3o Execute do VBScript? Como posso utiliz\u00e1-la? Solu\u00e7\u00e3o: A fun\u00e7\u00e3o Execute interpreta uma string como uma instru\u00e7\u00e3o do VBScript e a executa no contexto atual.&hellip;","og_url":"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:42:18+00:00","article_modified_time":"2021-08-09T17:35:42+00:00","author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"Utilizando a fun\u00e7\u00e3o Execute do VBScript.","datePublished":"2019-03-25T20:42:18+00:00","dateModified":"2021-08-09T17:35:42+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/"},"wordCount":193,"commentCount":1,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["Elipse E3","Scripts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/","url":"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/","name":"[:pt]Utilizando a fun\u00e7\u00e3o Execute do VBScript.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:42:18+00:00","dateModified":"2021-08-09T17:35:42+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/utilizando-a-funcao-execute-do-vbscript\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Utilizando a fun\u00e7\u00e3o Execute do VBScript."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3018"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=3018"}],"version-history":[{"count":3,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3018\/revisions"}],"predecessor-version":[{"id":12287,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3018\/revisions\/12287"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}