{"id":11627,"date":"2022-09-26T17:30:05","date_gmt":"2022-09-26T08:30:05","guid":{"rendered":"https:\/\/prodskill.com\/?p=11627"},"modified":"2022-10-04T23:07:30","modified_gmt":"2022-10-04T14:07:30","slug":"excel-vba-coding-pattern-performance-improvement","status":"publish","type":"post","link":"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/","title":{"rendered":"Patrones de codificaci\u00f3n de VBA: mejora del rendimiento de VBA"},"content":{"rendered":"<p>En este art\u00edculo, veremos c\u00f3mo mejorar el rendimiento de VBA.<\/p>\n\n\n\n<p>En el art\u00edculo anterior, comparamos el m\u00e9todo VBA Range Loop y confirmamos que el m\u00e9todo que usa Variant Array es el m\u00e1s r\u00e1pido.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-range-loop-read\/\">Patr\u00f3n de codificaci\u00f3n VBA: bucle de rango - lectura<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Tabla de contenidos&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Pesta\u00f1a de contenido alternativo\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Palanca<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/#1_%EC%84%B1%EB%8A%A5_%EA%B4%80%EB%A0%A8_VBA_%EC%A0%84%EC%97%AD_%EB%B3%80%EC%88%98\" >1. Variables globales de VBA relacionadas con el rendimiento<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/#11_ApplicationScreenUpdating\" >1.1. Aplicaci\u00f3n.Actualizaci\u00f3n de pantalla<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/#12_ApplicationDisplayAlerts\" >1.2. Aplicaci\u00f3n.DisplayAlerts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/#13_ApplicationCalculation\" >1.3. Aplicaci\u00f3n C\u00e1lculo<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/#14_ApplicationEnableEvents\" >1.4. Aplicaci\u00f3n EnableEvents<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/#2_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\" >2. C\u00f3digo de ejemplo<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/#21_%EC%A0%81%EC%9A%A9%EC%9D%B4_%EC%A0%81%ED%95%A9%ED%95%9C_%EA%B2%BD%EC%9A%B0\" >2.1. \u00bfCu\u00e1ndo conviene aplicar?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/#22_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\" >2.2. c\u00f3digo de ejemplo<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"1._\uc131\ub2a5_\uad00\ub828_VBA_\uc804\uc5ed_\ubcc0\uc218\"><span class=\"ez-toc-section\" id=\"1_%EC%84%B1%EB%8A%A5_%EA%B4%80%EB%A0%A8_VBA_%EC%A0%84%EC%97%AD_%EB%B3%80%EC%88%98\"><\/span>1. Variables globales de VBA relacionadas con el rendimiento<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Aqu\u00ed hay un resumen de todas las variables.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png\"><img loading=\"lazy\" decoding=\"async\" width=\"802\" height=\"345\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png\" alt=\"\uc131\ub2a5 \uad00\ub828 VBA \uc804\uc5ed \ubcc0\uc218\" class=\"wp-image-11628\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png 802w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-300x129.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-768x330.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-24x10.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-36x15.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-48x21.png 48w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><\/a><figcaption>Variables globales de VBA relacionadas con el rendimiento<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Examine el contenido de cada variable.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.1._Application.ScreenUpdating\"><span class=\"ez-toc-section\" id=\"11_ApplicationScreenUpdating\"><\/span>1.1. Aplicaci\u00f3n.Actualizaci\u00f3n de pantalla<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es una variable que controla si la pantalla se actualiza o no, y el valor por defecto es True (la pantalla se actualiza).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Mejora del rendimiento al configurar que no se actualice la pantalla (conversi\u00f3n de archivos, conversi\u00f3n de hojas, configuraci\u00f3n de valores de celda, etc.) durante la ejecuci\u00f3n del c\u00f3digo VBA<\/li><li>Eficaz cuando hay muchas actualizaciones de pantalla<\/li><li>Establ\u00e9zcalo en False al ingresar el c\u00f3digo y vuelva a configurarlo en True al final del c\u00f3digo.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.2._Application.DisplayAlerts\"><span class=\"ez-toc-section\" id=\"12_ApplicationDisplayAlerts\"><\/span>1.2. Aplicaci\u00f3n.DisplayAlerts<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Una variable que controla si se muestra o no la ventana de advertencia, y el valor predeterminado es Verdadero (se muestra la ventana de alerta).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Evita que el c\u00f3digo se detenga en el medio al no mostrar ventanas de advertencia (por ejemplo, la ventana &quot;\u00bfDesea guardar?&quot; cuando intenta cerrar un archivo que ha cambiado) durante la ejecuci\u00f3n del c\u00f3digo VBA<\/li><li>Establ\u00e9zcalo en False al ingresar el c\u00f3digo y vuelva a configurarlo en True al final del c\u00f3digo.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.3._Application.Calculation\"><span class=\"ez-toc-section\" id=\"13_ApplicationCalculation\"><\/span>1.3. Aplicaci\u00f3n C\u00e1lculo<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Esta es una variable que controla el m\u00e9todo de c\u00e1lculo de la f\u00f3rmula y el valor predeterminado es xlCalculationAutomatic (c\u00e1lculo autom\u00e1tico).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Evite el c\u00e1lculo autom\u00e1tico de f\u00f3rmulas (COUNTIF, VLOOKUP, etc.) durante la ejecuci\u00f3n del c\u00f3digo VBA<\/li><li>Eficaz para muchas f\u00f3rmulas.<\/li><li>Establ\u00e9zcalo en xlCalculationManual al ingresar el c\u00f3digo y vuelva a configurarlo en xlCalculationAutomatic al final del c\u00f3digo<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.4._Application.EnableEvents\"><span class=\"ez-toc-section\" id=\"14_ApplicationEnableEvents\"><\/span>1.4. Aplicaci\u00f3n EnableEvents<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es una variable que controla si se procesan los eventos y el valor predeterminado es True (se procesan los eventos).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Evitar la ejecuci\u00f3n de c\u00f3digo que maneja eventos como Worksheet_Change cuando ocurren<\/li><li>Esto es efectivo si tiene un c\u00f3digo que maneja eventos.<\/li><li>Establ\u00e9zcalo en False al ingresar el c\u00f3digo y vuelva a configurarlo en True al final del c\u00f3digo.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2._\uc608\uc2dc_\ucf54\ub4dc\"><span class=\"ez-toc-section\" id=\"2_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\"><\/span>2. C\u00f3digo de ejemplo<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.1._\uc801\uc6a9\uc774_\uc801\ud569\ud55c_\uacbd\uc6b0\"><span class=\"ez-toc-section\" id=\"21_%EC%A0%81%EC%9A%A9%EC%9D%B4_%EC%A0%81%ED%95%A9%ED%95%9C_%EA%B2%BD%EC%9A%B0\"><\/span>2.1. \u00bfCu\u00e1ndo conviene aplicar?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Si el c\u00f3digo VBA contiene los siguientes casos, es apropiado aplicar el m\u00e9todo de mejora del rendimiento descrito en este art\u00edculo.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Al crear un nuevo archivo\/hoja<\/li><li>Al cambiar la hoja actual a otra hoja<\/li><li>En caso de cambiar continuamente la celda actualmente seleccionada dentro de una hoja<\/li><li>Al realizar c\u00e1lculos complejos, como c\u00e1lculos largos con muchas f\u00f3rmulas<\/li><\/ul>\n\n\n\n<p>En este caso, se suspende temporalmente la ejecuci\u00f3n del c\u00f3digo VBA y se procesan los eventos que requieren Excel, como actualizar la pantalla o calcular f\u00f3rmulas. El ejemplo m\u00e1s t\u00edpico de c\u00f3digo VBA lento es la actualizaci\u00f3n de pantalla. Puede mejorar el rendimiento suspendiendo temporalmente el procesamiento de otros eventos mientras se ejecuta el c\u00f3digo VBA y procesando otros eventos despu\u00e9s de que el c\u00f3digo VBA termine de ejecutarse.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.2._\uc608\uc2dc_\ucf54\ub4dc\"><span class=\"ez-toc-section\" id=\"22_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\"><\/span>2.2. c\u00f3digo de ejemplo<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Antes de ingresar el c\u00f3digo a procesar, la variable global se establece en un valor de mejora del rendimiento y, una vez que finaliza el procesamiento del c\u00f3digo, se cambia al valor original. Consulte el siguiente c\u00f3digo.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'\ucf54\ub4dc \uc9c4\uc785 \ubd80\ubd84\nApplication.ScreenUpdating = False\nApplication.Calculation = xlCalculationManual\nApplication.EnableEvents = False\nApplication.DisplayAlerts = False\n\u00a0\n'\uc2e4\ud589\ud560 \ucf54\ub4dc\uac00 \ub4e4\uc5b4 \uac08 \ubd80\ubd84\n...\n\u00a0\n'\ucf54\ub4dc \uc885\ub8cc \ubd80\ubd84\nApplication.ScreenUpdating = True\nApplication.Calculation = xlCalculationAutomatic\nApplication.EnableEvents = True\nApplication.DisplayAlerts = True<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>Arriba, analizamos los patrones de codificaci\u00f3n de VBA para mejorar el rendimiento. Si tiene alguna pregunta, por favor deje un comentario.<\/p>","protected":false},"excerpt":{"rendered":"<p>En este art\u00edculo, veremos c\u00f3mo mejorar el rendimiento de VBA. En el art\u00edculo anterior, comparamos el m\u00e9todo VBA Range Loop y confirmamos que el m\u00e9todo que usa Variant Array es el m\u00e1s r\u00e1pido. Patr\u00f3n de codificaci\u00f3n de VBA: Bucle de rango - Lectura 1. Variables globales de VBA relacionadas con el rendimiento Aqu\u00ed hay un resumen de todas las variables....<\/p>","protected":false},"author":1,"featured_media":11628,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[17,74,75,96],"class_list":["post-11627","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-coding-pattern","tag-vba","tag-74","tag-codding-pattern","tag-96"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-26T08:30:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T14:07:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"345\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1\",\"datePublished\":\"2022-09-26T08:30:05+00:00\",\"dateModified\":\"2022-10-04T14:07:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\"},\"wordCount\":98,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"keywords\":[\"\uc5d1\uc140VBA\",\"\ucf54\ub529\ud328\ud134\",\"Codding Pattern\",\"\uc131\ub2a5 \ud5a5\uc0c1\"],\"articleSection\":[\"\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\",\"name\":\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"datePublished\":\"2022-09-26T08:30:05+00:00\",\"dateModified\":\"2022-10-04T14:07:30+00:00\",\"description\":\"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"width\":802,\"height\":345},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\"},\"url\":\"https:\\\/\\\/prodskill.com\\\/es\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Patrones de codificaci\u00f3n de VBA: C\u00f3mo mejorar el rendimiento de VBA - Habilidades de productividad","description":"Este art\u00edculo explora maneras de mejorar el rendimiento de VBA en Excel. Aprender\u00e1 sobre cuatro variables globales de VBA que afectan al rendimiento (ScreenUpdating, DisplayAlerts, Calculation y EnableEvents), junto con un c\u00f3digo de ejemplo.","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:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/","og_locale":"es_ES","og_type":"article","og_title":"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-26T08:30:05+00:00","article_modified_time":"2022-10-04T14:07:30+00:00","og_image":[{"width":802,"height":345,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Zerom","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1","datePublished":"2022-09-26T08:30:05+00:00","dateModified":"2022-10-04T14:07:30+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/"},"wordCount":98,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","keywords":["\uc5d1\uc140VBA","\ucf54\ub529\ud328\ud134","Codding Pattern","\uc131\ub2a5 \ud5a5\uc0c1"],"articleSection":["\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/","url":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/","name":"Patrones de codificaci\u00f3n de VBA: C\u00f3mo mejorar el rendimiento de VBA - Habilidades de productividad","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","datePublished":"2022-09-26T08:30:05+00:00","dateModified":"2022-10-04T14:07:30+00:00","description":"Este art\u00edculo explora maneras de mejorar el rendimiento de VBA en Excel. Aprender\u00e1 sobre cuatro variables globales de VBA que afectan al rendimiento (ScreenUpdating, DisplayAlerts, Calculation y EnableEvents), junto con un c\u00f3digo de ejemplo.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","width":802,"height":345},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Habilidades de productividad","description":"Meta Pensamiento, Meta Trabajo","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Cerom","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/es\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11627","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/comments?post=11627"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11627\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media\/11628"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media?parent=11627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/categories?post=11627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/tags?post=11627"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}