{"id":11307,"date":"2022-09-11T00:51:40","date_gmt":"2022-09-10T15:51:40","guid":{"rendered":"https:\/\/prodskill.com\/?p=11307"},"modified":"2024-09-08T10:00:52","modified_gmt":"2024-09-08T01:00:52","slug":"excel-vba-lecture-1-overview","status":"publish","type":"post","link":"https:\/\/prodskill.com\/es\/excel-vba-lecture-1-overview\/","title":{"rendered":"Curso Excel VBA(1): Descripci\u00f3n general de Excel VBA"},"content":{"rendered":"<p>Esta es la primera publicaci\u00f3n de la vista previa del curso anterior de Excel VBA.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-preface\/\">Inicie el curso de Excel VBA. (Aviso de conferencia, haza\u00f1a. Por qu\u00e9 recomendamos Excel VBA)<\/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-lecture-1-overview\/#1_%EC%97%91%EC%85%80_VBA_%EA%B0%9C%EC%9A%94\" >1. Descripci\u00f3n general de Excel VBA<\/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-lecture-1-overview\/#11_VBA_Macro_%EA%B0%9C%EB%85%90\" >1.1. VBA, conceptos macro<\/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-lecture-1-overview\/#12_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%A0%91%EA%B7%BC%ED%95%98%EB%8A%94%EB%8D%B0_%ED%95%84%EC%9A%94%ED%95%9C_%EA%B2%BD%ED%97%98_%EC%A7%80%EC%8B%9D_%EB%A7%88%EC%9D%8C%EA%B0%80%EC%A7%90\" >1.2. La experiencia, el conocimiento y la mentalidad necesarios para acercarse a Excel VBA<\/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-lecture-1-overview\/#13_%EC%97%91%EC%85%80_VBA%EB%A1%9C_%EB%AC%B4%EC%97%87%EC%9D%84_%ED%95%A0_%EC%88%98_%EC%9E%88%EB%82%98\" >1.3. \u00bfQu\u00e9 se puede hacer con Excel VBA?<\/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-lecture-1-overview\/#14_%EC%97%91%EC%85%80_VBA_%ED%95%99%EC%8A%B5%EC%9D%98_%EB%8B%A8%EA%B3%84%EC%A0%81_%EC%A0%91%EA%B7%BC\" >1.4. Un enfoque paso a paso para aprender Excel VBA<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-1-overview\/#15_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%96%B4%EB%A0%A4%EC%9B%8C_%ED%95%98%EB%8A%94_%EC%9A%94%EC%86%8C%EC%99%80_%ED%95%B4%EA%B2%B0%EB%B0%A9%EB%B2%95\" >1.5. Factores que dificultan Excel VBA y c\u00f3mo solucionarlo<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-1-overview\/#16_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%A0_%EB%95%8C%EC%99%80_%EC%82%AC%EC%9A%A9%ED%95%98%EC%A7%80_%EB%A7%90%EC%95%84%EC%95%BC_%ED%95%A0_%EB%95%8C\" >1.6. Cu\u00e1ndo usar Excel VBA y cu\u00e1ndo no usarlo<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-1-overview\/#161_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%A0_%EB%95%8C\" >1.6.1. Al usar Excel VBA<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-1-overview\/#161_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%98%EC%A7%80_%EB%A7%90%EC%95%84%EC%95%BC_%ED%95%A0_%EB%95%8C\" >1.6.1. Cu\u00e1ndo no usar Excel VBA<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"1._\uc5d1\uc140_VBA_\uac1c\uc694\"><span class=\"ez-toc-section\" id=\"1_%EC%97%91%EC%85%80_VBA_%EA%B0%9C%EC%9A%94\"><\/span>1. Descripci\u00f3n general de Excel VBA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Una funci\u00f3n escrita en el lenguaje VBA similar a VB se llama Macro.<\/strong><\/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-54.png\"><img loading=\"lazy\" decoding=\"async\" width=\"572\" height=\"217\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54.png\" alt=\"VBA Logo\" class=\"wp-image-11309\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54.png 572w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54-300x114.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54-18x7.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54-24x9.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54-36x14.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54-48x18.png 48w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><\/a><figcaption class=\"wp-element-caption\">Logotipo de VBA<\/figcaption><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"1.1._VBA,_Macro_\uac1c\ub150\"><span class=\"ez-toc-section\" id=\"11_VBA_Macro_%EA%B0%9C%EB%85%90\"><\/span>1.1. VBA, conceptos macro<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Visual Basic for Application (VBA) est\u00e1 integrado en los productos de MS Office (Excel, PowerPoint, Word, Access, Visio, etc.)&nbsp;<strong>lenguaje de desarrollo<\/strong>(y entorno de desarrollo).<\/p>\n\n\n\n<p>Macro significa lo siguiente.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Automatizaci\u00f3n de tareas repetitivas\u00a0<strong>funci\u00f3n<\/strong><\/li>\n\n\n\n<li>Procedimiento (procedimiento de procesamiento, funci\u00f3n) escrito en VBA (lenguaje de desarrollo)<\/li>\n<\/ol>\n\n\n\n<p><strong>Estrictamente hablando, las funciones escritas en lenguaje VBA tienen diferentes significados porque son Macros, pero VBA y Macro pueden considerarse con el mismo significado.<\/strong>&nbsp;VBA es la mejor herramienta para maximizar el uso de Excel, y es la mejor herramienta que puede ayudar en gran medida a mejorar la productividad (cantidad y calidad de los resultados frente al tiempo de inversi\u00f3n).<\/p>\n\n\n\n<p>VBA es un lenguaje de interpretaci\u00f3n, no un lenguaje de compilaci\u00f3n, y no es necesario instalar una herramienta de desarrollo independiente (Visual Studio, Eclipse, Delphi, etc.). (Ya est\u00e1 incluido en los productos de MS Office) Tiene la ventaja de un desarrollo e implementaci\u00f3n simples.<\/p>\n\n\n\n<p>Hay poca diferencia ling\u00fc\u00edstica entre VB y VBA, pero VBA no admite subprocesos m\u00faltiples y tiene la limitaci\u00f3n de que no puede crear archivos ejecutables independientes (.exe, .dll, etc.).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.2._\uc5d1\uc140_VBA\ub97c_\uc811\uadfc\ud558\ub294\ub370_\ud544\uc694\ud55c_\uacbd\ud5d8,_\uc9c0\uc2dd,_\ub9c8\uc74c\uac00\uc9d0\"><span class=\"ez-toc-section\" id=\"12_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%A0%91%EA%B7%BC%ED%95%98%EB%8A%94%EB%8D%B0_%ED%95%84%EC%9A%94%ED%95%9C_%EA%B2%BD%ED%97%98_%EC%A7%80%EC%8B%9D_%EB%A7%88%EC%9D%8C%EA%B0%80%EC%A7%90\"><\/span>1.2. La experiencia, el conocimiento y la mentalidad necesarios para acercarse a Excel VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Mucha gente usa Excel, pero no mucha gente usa Excel VBA. Mucha gente ni siquiera sabe que existe Excel VBA, y muchas personas no lo tocan a pesar de que saben que es \u00fatil.<\/p>\n\n\n\n<p>Al comenzar con Excel VBA, tenga en cuenta lo siguiente.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Para usar bien Excel VBA, debe usar bien Excel.<\/li>\n\n\n\n<li>Si tiene experiencia en el desarrollo de aplicaciones (C\/S, Web, Shell script, etc.), puede aprender r\u00e1pidamente el idioma.<\/li>\n\n\n\n<li>Lo mejor es tener una comprensi\u00f3n de la sintaxis del lenguaje Visual Basic.<\/li>\n\n\n\n<li>Debe comprender el modelo de objetos de Excel.<\/li>\n\n\n\n<li>Requiere imaginaci\u00f3n (\u00bfEs esto posible? \u00bfEsto ayudar\u00e1 al trabajo? etc.).<\/li>\n\n\n\n<li>Se requiere poder de b\u00fasqueda (usar bien Google).<\/li>\n\n\n\n<li>Es bueno abordarlo con la mente de ensamblar (muchos componentes, mash-up de servicios, etc.).<\/li>\n\n\n\n<li>Lo m\u00e1s importante es la mente y la voluntad para resolverlo por tu cuenta.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.3._\uc5d1\uc140_VBA\ub85c_\ubb34\uc5c7\uc744_\ud560_\uc218_\uc788\ub098?\"><span class=\"ez-toc-section\" id=\"13_%EC%97%91%EC%85%80_VBA%EB%A1%9C_%EB%AC%B4%EC%97%87%EC%9D%84_%ED%95%A0_%EC%88%98_%EC%9E%88%EB%82%98\"><\/span>1.3. \u00bfQu\u00e9 se puede hacer con Excel VBA?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es posible expandirse casi infinitamente, incluyendo todas las funciones que puede hacer Excel, nuevas funciones que combinan cada funci\u00f3n y funciones de extensi\u00f3n usando objetos de referencia externos.<\/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-55.png\"><img loading=\"lazy\" decoding=\"async\" width=\"977\" height=\"548\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-55.png\" alt=\"\uc5d1\uc140 VBA\ub85c \ud560 \uc218 \uc788\ub294 \uac83\ub4e4\" class=\"wp-image-11310\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-55.png 977w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-55-300x168.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-55-768x431.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-55-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-55-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-55-36x20.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-55-48x27.png 48w\" sizes=\"auto, (max-width: 977px) 100vw, 977px\" \/><\/a><figcaption class=\"wp-element-caption\">Lo que puede hacer con Excel VBA<\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Automatiza tareas repetitivas en Excel<\/li>\n\n\n\n<li>Cree y use funciones definidas por el usuario adem\u00e1s de las funciones integradas<\/li>\n\n\n\n<li>Crear, fusionar, dividir muchos archivos de Excel<\/li>\n\n\n\n<li>Graba m\u00faltiples pasos que se usan repetidamente con frecuencia, convirti\u00e9ndolos en una sola funci\u00f3n y asignando teclas de m\u00e9todo abreviado para que sean m\u00e1s f\u00e1ciles de usar<\/li>\n\n\n\n<li>Ampl\u00ede la funcionalidad de Excel creando un complemento de Excel<\/li>\n\n\n\n<li>Procesamiento CRUD en conexi\u00f3n con la base de datos (carga y descarga de datos de Excel, informe de estado actual\/creaci\u00f3n de gr\u00e1ficos, etc.)<\/li>\n\n\n\n<li>Enlace web (b\u00fasqueda de diccionario de Naver, aplicaci\u00f3n de registro de lotes de t\u00e9rminos metaest\u00e1ndar, etc.)<\/li>\n\n\n\n<li>Procesamiento masivo junto con otras aplicaciones, generaci\u00f3n autom\u00e1tica de informes\/resultados<\/li>\n\n\n\n<li>Automatice el procesamiento de tareas que crea archivos de script como UNiX shell, SQL, PL\/SQL, etc.<\/li>\n\n\n\n<li>Adem\u00e1s, casi todo en el aspecto S\/W es posible siempre y cuando tengas la voluntad de imaginarlo, buscarlo y hacerlo.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.4._\uc5d1\uc140_VBA_\ud559\uc2b5\uc758_\ub2e8\uacc4\uc801_\uc811\uadfc\"><span class=\"ez-toc-section\" id=\"14_%EC%97%91%EC%85%80_VBA_%ED%95%99%EC%8A%B5%EC%9D%98_%EB%8B%A8%EA%B3%84%EC%A0%81_%EC%A0%91%EA%B7%BC\"><\/span>1.4. Un enfoque paso a paso para aprender Excel VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es necesario aprender las habilidades b\u00e1sicas dividi\u00e9ndolas en una etapa de aprendizaje y una etapa de uso.<\/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-56.png\"><img loading=\"lazy\" decoding=\"async\" width=\"713\" height=\"496\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-56.png\" alt=\"\uc5d1\uc140 VBA \ud559\uc2b5 \ub2e8\uacc4\" class=\"wp-image-11311\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-56.png 713w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-56-300x209.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-56-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-56-24x17.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-56-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-56-48x33.png 48w\" sizes=\"auto, (max-width: 713px) 100vw, 713px\" \/><\/a><figcaption class=\"wp-element-caption\">Pasos de aprendizaje de Excel VBA<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Se recomienda aprender los pasos b\u00e1sicos en el siguiente orden: Paso 1) Aprendizaje del modelo de objetos, Paso 2) Aprendizaje de la sintaxis de VB, Paso 3) Manejo del modelo de objetos con VB. Un d\u00eda como m\u00ednimo o 3 d\u00edas como m\u00e1ximo es suficiente para aprender el concepto, y lleva de 1 a 2 semanas o m\u00e1s usarlo hasta cierto punto.<\/p>\n\n\n\n<p>Recomendamos aprender en el orden del Paso 4) Manejo de Objetos de Referencia Externa, Paso 5) Manejo de M\u00f3dulo\/Forma de Usuario, Paso 6) Manejo de Clase. Los objetos de referencia externa (por ejemplo, ADO para enlace DB, HttpRequest para enlace web, etc.) deben aprenderse por tipo.Cada objeto tiene diferentes usos y m\u00e9todos, por lo que es efectivo aprender los objetos necesarios en cada momento. En esta etapa de utilizaci\u00f3n, la cantidad de tiempo necesario para el aprendizaje y la utilizaci\u00f3n puede variar de una persona a otra.<\/p>\n\n\n\n<p>El siguiente es un diagrama que ilustra la dificultad\/productividad de aprendizaje de cada etapa de Excel VBA seg\u00fan el paso del tiempo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-57.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1010\" height=\"475\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-57.png\" alt=\"\uc5d1\uc140 VBA \ud559\uc2b5\/\ud65c\uc6a9 \uace1\uc120\" class=\"wp-image-11312\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-57.png 1010w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-57-300x141.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-57-768x361.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-57-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-57-520x245.png 520w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-57-720x340.png 720w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-57-24x11.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-57-36x17.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-57-48x23.png 48w\" sizes=\"auto, (max-width: 1010px) 100vw, 1010px\" \/><\/a><figcaption class=\"wp-element-caption\">Curva de aprendizaje\/utilizaci\u00f3n de Excel VBA<\/figcaption><\/figure>\n\n\n\n<p>Debe tener al menos el nivel 3 antes de que pueda usarse de manera \u00fatil para el trabajo y pueda ser \u00fatil. Paso 1) Modelo de objetos de aprendizaje o Paso 2) Aprender sintaxis de VB por un tiempo y luego darse por vencido en muchos casos. No te rindas Paso 3) Hag\u00e1moslo hasta el manejo del modelo de objetos con VB.<\/p>\n\n\n\n<p>Lo que no debe malinterpretarse aqu\u00ed es que no tiene que aprender todos los modelos de objetos y toda la sintaxis de VB para manejar modelos de objetos con VB. M\u00e1s bien, si aprendes as\u00ed, te aburrir\u00e1s r\u00e1pidamente y te dar\u00e1s por vencido f\u00e1cilmente porque no es divertido. Si te encuentras con algo que no conoces, puedes buscarlo en Google de vez en cuando y avanzar poco a poco.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>* Referencia: <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/library-reference\/concepts\/getting-started-with-vba-in-office\" target=\"_blank\" rel=\"noreferrer noopener\">Comenzando con VBA en Office (Microsoft Learn)<\/a><\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.5._\uc5d1\uc140_VBA\ub97c_\uc5b4\ub824\uc6cc_\ud558\ub294_\uc694\uc18c\uc640_\ud574\uacb0\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"15_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%96%B4%EB%A0%A4%EC%9B%8C_%ED%95%98%EB%8A%94_%EC%9A%94%EC%86%8C%EC%99%80_%ED%95%B4%EA%B2%B0%EB%B0%A9%EB%B2%95\"><\/span>1.5. Factores que dificultan Excel VBA y c\u00f3mo solucionarlo<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>La sintaxis de VB no me es familiar, no lo s\u00e9, y de todos modos es dif\u00edcil.<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>La sintaxis de VB es tan simple en comparaci\u00f3n con C, C++ o Java que puede aprender los conceptos b\u00e1sicos en una hora.<br>Aunque OOP es posible en VB, tiene muchas limitaciones y es tan simple en comparaci\u00f3n con C++ y Java.<\/p>\n<\/blockquote>\n\n\n\n<ul class=\"wp-block-list\">\n<li>No estoy familiarizado con el modelo de objetos de Excel.<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Puede aprender el modelo de objetos b\u00e1sico de Excel en 5 minutos.<br>Si no est\u00e1 seguro, puede usar la grabadora de macros o buscarla en Google.<\/p>\n<\/blockquote>\n\n\n\n<ul class=\"wp-block-list\">\n<li>No estoy seguro de c\u00f3mo implementar la funci\u00f3n requerida.<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Si lo busca en Google, puede encontrar c\u00f3digo que ya est\u00e1 implementado en la mayor\u00eda de los casos (90% y superior).<\/p>\n<\/blockquote>\n\n\n\n<ul class=\"wp-block-list\">\n<li>No s\u00e9 por qu\u00e9 tengo que hacer esto.<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Si lo haces t\u00fa mismo, puedes ver que la productividad del trabajo personal mejora.<br>Cuando m\u00e1s personas pueden usar VBA, la productividad del proyecto\/equipo aumenta.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.6._\uc5d1\uc140_VBA\ub97c_\uc0ac\uc6a9\ud560_\ub54c\uc640_\uc0ac\uc6a9\ud558\uc9c0_\ub9d0\uc544\uc57c_\ud560_\ub54c\"><span class=\"ez-toc-section\" id=\"16_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%A0_%EB%95%8C%EC%99%80_%EC%82%AC%EC%9A%A9%ED%95%98%EC%A7%80_%EB%A7%90%EC%95%84%EC%95%BC_%ED%95%A0_%EB%95%8C\"><\/span>1.6. Cu\u00e1ndo usar Excel VBA y cu\u00e1ndo no usarlo<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Depender\u00e1 de las circunstancias y circunstancias de cada individuo, pero en general se siguen los siguientes criterios.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"1.6.1._\uc5d1\uc140_VBA\ub97c_\uc0ac\uc6a9\ud560_\ub54c\"><span class=\"ez-toc-section\" id=\"161_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%A0_%EB%95%8C\"><\/span>1.6.1. Al usar Excel VBA<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cuando se espera que tomar\u00e1 mucho menos tiempo escribir c\u00f3digo VBA que el tiempo requerido para el trabajo manual<\/li>\n\n\n\n<li>Es una operaci\u00f3n \u00fanica, pero cuando se considera efectiva al escribir c\u00f3digo VBA<\/li>\n\n\n\n<li>Cuando es seguro que la tarea se repetir\u00e1 dos o m\u00e1s veces<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"1.6.1._\uc5d1\uc140_VBA\ub97c_\uc0ac\uc6a9\ud558\uc9c0_\ub9d0\uc544\uc57c_\ud560_\ub54c\"><span class=\"ez-toc-section\" id=\"161_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%98%EC%A7%80_%EB%A7%90%EC%95%84%EC%95%BC_%ED%95%A0_%EB%95%8C\"><\/span>1.6.1. Cu\u00e1ndo no usar Excel VBA<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Al escribir c\u00f3digo VBA y no seguir el horario (si el ombligo es m\u00e1s grande que el ombligo)<\/li>\n\n\n\n<li>Cuando se trata de una operaci\u00f3n \u00fanica y la operaci\u00f3n manual es m\u00e1s r\u00e1pida<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>Hasta ahora, hemos visto la descripci\u00f3n general de Excel VBA. A continuaci\u00f3n, veremos los conceptos b\u00e1sicos de Excel VBA. Si tiene alguna pregunta, por favor deje un comentario.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt; Lista de art\u00edculos relacionados &gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-preface\/\">Inicie el curso de Excel VBA. (Aviso de conferencia, haza\u00f1a. Por qu\u00e9 recomendamos Excel VBA)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-1-overview\/\">Curso Excel VBA(1): Descripci\u00f3n general de Excel VBA<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-2-basic\/\">Curso de Excel VBA (2): Conceptos b\u00e1sicos de Excel VBA<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-3-object-model\/\">Curso de Excel VBA (3): Modelo de objetos de Excel<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-4-handling-object-model\/\">Curso de Excel VBA (4): Trabajar con el modelo de objetos de Excel<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">Curso de Excel VBA (5): extensi\u00f3n de archivo de Excel, VBE, configuraci\u00f3n de fuente<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-6-variable\/\">Curso Excel VBA (6): Conceptos b\u00e1sicos del lenguaje Excel VBA - Variables<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-7-syntax\/\">Curso Excel VBA (7): Conceptos b\u00e1sicos del lenguaje Excel VBA - Sintaxis<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-8-datatype\/\">Curso Excel VBA (8): Conceptos b\u00e1sicos del lenguaje Excel VBA: tipos de datos, estructuras de datos<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/\">Cursos de Excel VBA (9): Procedimientos de Excel VBA<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-10-self-developed-tools\/\">Curso Excel VBA (10): Herramientas desarrolladas y utilizadas con Excel VBA<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-toc\/\">Tabla de contenido completa para cursos de Excel VBA<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Este es el primer art\u00edculo de la vista previa de la conferencia anterior de Excel VBA. Bienvenido al curso de Excel VBA. (Vista previa del curso, con Razones para recomendar Excel VBA) 1. Descripci\u00f3n general de Excel VBA Una funci\u00f3n escrita en lenguaje VBA, similar a VB, se llama Macro. 1.1. VBA, concepto macro VBA (Visual Basic para aplicaciones) es un lenguaje de desarrollo (y...<\/p>","protected":false},"author":1,"featured_media":11309,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-tutorial","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc5d1\uc140 VBA \uac1c\uc694 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc5d1\uc140 VBA\uc5d0\uc11c VBA(Visual Basic for Application)\ub294 MS Office \uc81c\ud488(Excel, PowerPoint, Word, Access \ub4f1)\uc5d0 \ub0b4\uc7a5\ub41c\u00a0\uac1c\ubc1c \uc5b8\uc5b4(\ubc0f \uac1c\ubc1c \ud658\uacbd)\uc744 \uc758\ubbf8\ud55c\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-lecture-1-overview\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc5d1\uc140 VBA \uac1c\uc694 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc5d1\uc140 VBA\uc5d0\uc11c VBA(Visual Basic for Application)\ub294 MS Office \uc81c\ud488(Excel, PowerPoint, Word, Access \ub4f1)\uc5d0 \ub0b4\uc7a5\ub41c\u00a0\uac1c\ubc1c \uc5b8\uc5b4(\ubc0f \uac1c\ubc1c \ud658\uacbd)\uc744 \uc758\ubbf8\ud55c\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-1-overview\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-10T15:51:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-08T01:00:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54.png\" \/>\n\t<meta property=\"og:image:width\" content=\"572\" \/>\n\t<meta property=\"og:image:height\" content=\"217\" \/>\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=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694\",\"datePublished\":\"2022-09-10T15:51:40+00:00\",\"dateModified\":\"2024-09-08T01:00:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/\"},\"wordCount\":217,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-54.png\",\"keywords\":[\"\uc5d1\uc140VBA\"],\"articleSection\":[\"\uc5d1\uc140 VBA \uac15\uc88c\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-54.png\",\"datePublished\":\"2022-09-10T15:51:40+00:00\",\"dateModified\":\"2024-09-08T01:00:52+00:00\",\"description\":\"\uc5d1\uc140 VBA \uac1c\uc694 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc5d1\uc140 VBA\uc5d0\uc11c VBA(Visual Basic for Application)\ub294 MS Office \uc81c\ud488(Excel, PowerPoint, Word, Access \ub4f1)\uc5d0 \ub0b4\uc7a5\ub41c\u00a0\uac1c\ubc1c \uc5b8\uc5b4(\ubc0f \uac1c\ubc1c \ud658\uacbd)\uc744 \uc758\ubbf8\ud55c\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-54.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-54.png\",\"width\":572,\"height\":217},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-1-overview\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694\"}]},{\"@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":"\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694 - \uc0dd\uc0b0\uc131 Skill","description":"\uc5d1\uc140 VBA \uac1c\uc694 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc5d1\uc140 VBA\uc5d0\uc11c VBA(Visual Basic for Application)\ub294 MS Office \uc81c\ud488(Excel, PowerPoint, Word, Access \ub4f1)\uc5d0 \ub0b4\uc7a5\ub41c\u00a0\uac1c\ubc1c \uc5b8\uc5b4(\ubc0f \uac1c\ubc1c \ud658\uacbd)\uc744 \uc758\ubbf8\ud55c\ub2e4.","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-lecture-1-overview\/","og_locale":"es_ES","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc5d1\uc140 VBA \uac1c\uc694 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc5d1\uc140 VBA\uc5d0\uc11c VBA(Visual Basic for Application)\ub294 MS Office \uc81c\ud488(Excel, PowerPoint, Word, Access \ub4f1)\uc5d0 \ub0b4\uc7a5\ub41c\u00a0\uac1c\ubc1c \uc5b8\uc5b4(\ubc0f \uac1c\ubc1c \ud658\uacbd)\uc744 \uc758\ubbf8\ud55c\ub2e4.","og_url":"https:\/\/prodskill.com\/es\/excel-vba-lecture-1-overview\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-10T15:51:40+00:00","article_modified_time":"2024-09-08T01:00:52+00:00","og_image":[{"width":572,"height":217,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Zerom","Tiempo de lectura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694","datePublished":"2022-09-10T15:51:40+00:00","dateModified":"2024-09-08T01:00:52+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/"},"wordCount":217,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54.png","keywords":["\uc5d1\uc140VBA"],"articleSection":["\uc5d1\uc140 VBA \uac15\uc88c"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/","name":"\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694 - \uc0dd\uc0b0\uc131 Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54.png","datePublished":"2022-09-10T15:51:40+00:00","dateModified":"2024-09-08T01:00:52+00:00","description":"\uc5d1\uc140 VBA \uac1c\uc694 \uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc5d1\uc140 VBA\uc5d0\uc11c VBA(Visual Basic for Application)\ub294 MS Office \uc81c\ud488(Excel, PowerPoint, Word, Access \ub4f1)\uc5d0 \ub0b4\uc7a5\ub41c\u00a0\uac1c\ubc1c \uc5b8\uc5b4(\ubc0f \uac1c\ubc1c \ud658\uacbd)\uc744 \uc758\ubbf8\ud55c\ub2e4.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-54.png","width":572,"height":217},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694"}]},{"@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\/11307","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=11307"}],"version-history":[{"count":2,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11307\/revisions"}],"predecessor-version":[{"id":12502,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11307\/revisions\/12502"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media\/11309"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media?parent=11307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/categories?post=11307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/tags?post=11307"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}