{"id":3092,"date":"2019-03-25T17:42:40","date_gmt":"2019-03-25T20:42:40","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/using-vbscripts-execute-function\/"},"modified":"2021-08-09T14:36:20","modified_gmt":"2021-08-09T17:36:20","slug":"using-vbscripts-execute-function","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/","title":{"rendered":"Using VBScript\u2019s Execute function."},"content":{"rendered":"<div align=\"justify\">\n<p><b>Question:<\/b><\/p>\n<p>What is VBScript&#8217;s Execute function for? How can I use it?<br \/>\n<b><br \/>\nSolution:<\/b><\/p>\n<p>VBScript&#8217;s <i>Execute <\/i>function interprets a string as a VBScript instruction and executes it in the current context. It is useful for creating scripts that check or attribute values of properties with sequential names. For example, values are usually attributed in properties like this:<\/p>\n<pre><span style=\"font-family: Courier New\">Application.GetObject(\"Data.XObject1\").Property1 = 0<\/span><\/pre>\n<p>However, when you need to update values in a large group of properties, you can use <i>Execute <\/i>function. The two examples below will perform the exact same action, but you will be able to better understand the difference between using a simple attribution and an attribution via <i>Execute <\/i>method.<\/p>\n<p><u><b>Simple attribution <\/b><\/u><\/p>\n<pre><span style=\"font-family: Courier New\">Application.GetObject(\"Data.XObject1\").Property1 = 1\r\nApplication.GetObject(\"Data.XObject1\").Property2 = 1\r\nApplication.GetObject(\"Data.XObject1\").Property3 = 0\r\n...\r\nApplication.GetObject(\"Data.XObject1\").Property200 = 0<\/span><\/pre>\n<p><u><b>Attribution using <i>Execute <\/i>function<\/b><\/u><\/p>\n<pre><span style=\"font-family: Courier New\">Set obj = Application.GetObject(\"Data.XObject1\")\r\nFor i=1 to 200\r\nExecute \"obj.Property\" & CStr(i) & \" = 1 \"\r\nNext<\/span><\/pre>\n<p>Notice that scripts using <i>Execute <\/i>function are usually smaller, which makes maintaining\/debugging them easier.<\/p>\n<p>The sample application attached to this article shows <i>Execute <\/i>function changing the values of properties in an XObject.<\/p>\n<\/div>\n<div align=\"justify\"><\/div>\n<h3 align=\"justify\">Attachments:<\/h3>\n<p><a href=\"\/wp-content\/uploads\/2019\/03\/Sample-1.zip\">Sample<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Autor<br \/>\nPedro Henrique Jochims Rossi<\/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":[763],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using VBScript\u2019s Execute function. - 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\/en\/using-vbscripts-execute-function\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using VBScript\u2019s Execute function.\" \/>\n<meta property=\"og:description\" content=\"Autor Pedro Henrique Jochims Rossi\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/\" \/>\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:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-09T17:36:20+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\/en\/using-vbscripts-execute-function\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"Using VBScript\u2019s Execute function.\",\"datePublished\":\"2019-03-25T20:42:40+00:00\",\"dateModified\":\"2021-08-09T17:36:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/\"},\"wordCount\":153,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"Scripts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/\",\"name\":\"[:pt]Using VBScript\u2019s Execute function.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:42:40+00:00\",\"dateModified\":\"2021-08-09T17:36:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using VBScript\u2019s Execute function.\"}]},{\"@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":"Using VBScript\u2019s Execute function. - 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\/en\/using-vbscripts-execute-function\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]Using VBScript\u2019s Execute function.[:] - Elipse Knowledgebase","og_description":"[:pt]Autor Pedro Henrique Jochims Rossi[:]","og_url":"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:42:40+00:00","article_modified_time":"2021-08-09T17:36:20+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\/en\/using-vbscripts-execute-function\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"Using VBScript\u2019s Execute function.","datePublished":"2019-03-25T20:42:40+00:00","dateModified":"2021-08-09T17:36:20+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/"},"wordCount":153,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["Scripts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/","url":"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/","name":"[:pt]Using VBScript\u2019s Execute function.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:42:40+00:00","dateModified":"2021-08-09T17:36:20+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/using-vbscripts-execute-function\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Using VBScript\u2019s Execute function."}]},{"@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\/3092"}],"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=3092"}],"version-history":[{"count":5,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3092\/revisions"}],"predecessor-version":[{"id":12289,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3092\/revisions\/12289"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}