{"id":11413,"date":"2022-09-11T22:32:13","date_gmt":"2022-09-11T13:32:13","guid":{"rendered":"https:\/\/prodskill.com\/?p=11413"},"modified":"2022-10-11T11:43:18","modified_gmt":"2022-10-11T02:43:18","slug":"excel-vba-lecture-10-self-developed-tools","status":"publish","type":"post","link":"https:\/\/prodskill.com\/es\/excel-vba-lecture-10-self-developed-tools\/","title":{"rendered":"Curso Excel VBA (10): Herramientas desarrolladas y utilizadas con Excel VBA"},"content":{"rendered":"<p>En este art\u00edculo, miro ejemplos de herramientas que he desarrollado y usado con Excel VBA.<\/p>\n\n\n\n<p>Esta es una continuaci\u00f3n del art\u00edculo anterior.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/\">Cursos de Excel VBA (9): Procedimientos de Excel VBA<\/a><\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\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-10-self-developed-tools\/#5_%EC%97%91%EC%85%80_VBA%EB%A1%9C_%EA%B0%9C%EB%B0%9C%ED%95%98%EC%97%AC_%EC%82%AC%EC%9A%A9%EC%A4%91%EC%9D%B8_%EB%8F%84%EA%B5%AC\" >5. Herramientas desarrolladas con 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-10-self-developed-tools\/#51_%EB%84%A4%EC%9D%B4%EB%B2%84_%EA%B5%AD%EC%96%B4%EC%82%AC%EC%A0%84_%EC%98%81%EC%96%B4%EC%82%AC%EC%A0%84_%EA%B2%80%EC%83%89_%EB%8F%84%EA%B5%AC\" >5.1. Diccionario coreano Naver, herramienta de b\u00fasqueda de diccionarios en ingl\u00e9s<\/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-10-self-developed-tools\/#52_1%EC%B0%A8%EC%9B%90_Bin_Packing_%EC%95%8C%EA%B3%A0%EB%A6%AC%EC%A6%98%EC%9D%84_%ED%99%9C%EC%9A%A9%ED%95%9C_%EC%9E%91%EC%97%85_%EB%B0%B0%EB%B6%84_%EC%B5%9C%EC%A0%81%ED%99%94_%EB%8F%84%EA%B5%AC\" >5.2. Herramienta de optimizaci\u00f3n de la asignaci\u00f3n de trabajo utilizando un algoritmo de empaque de contenedores unidimensional<\/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-10-self-developed-tools\/#53_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80_%EB%8F%84%EA%B5%AC\" >5.3. Herramienta de verificaci\u00f3n de est\u00e1ndares de datos<\/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-10-self-developed-tools\/#54_DA_Macro_%EB%8F%84%EA%B5%AC\" >5.4. Herramienta macro DA#<\/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-10-self-developed-tools\/#55_PowerDesigner_Macro_%EB%8F%84%EA%B5%AC\" >5.5. Herramienta Macro PowerDesigner<\/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-10-self-developed-tools\/#56_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EC%A0%84%ED%99%98%EC%9D%B4%ED%96%89_Migration_%EB%8F%84%EA%B5%AC\" >5.6. Herramientas de migraci\u00f3n de datos (migraci\u00f3n)<\/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-lecture-10-self-developed-tools\/#57_Excel_Data_Downloader\" >5.7. Descargador de datos de Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-10-self-developed-tools\/#58_Excel_Data_Uploader\" >5.8. Cargador de datos de Excel<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"5._\uc5d1\uc140_VBA\ub85c_\uac1c\ubc1c\ud558\uc5ec_\uc0ac\uc6a9\uc911\uc778_\ub3c4\uad6c\"><span class=\"ez-toc-section\" id=\"5_%EC%97%91%EC%85%80_VBA%EB%A1%9C_%EA%B0%9C%EB%B0%9C%ED%95%98%EC%97%AC_%EC%82%AC%EC%9A%A9%EC%A4%91%EC%9D%B8_%EB%8F%84%EA%B5%AC\"><\/span>5. Herramientas desarrolladas con Excel VBA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5.1._\ub124\uc774\ubc84_\uad6d\uc5b4\uc0ac\uc804,_\uc601\uc5b4\uc0ac\uc804_\uac80\uc0c9_\ub3c4\uad6c\"><span class=\"ez-toc-section\" id=\"51_%EB%84%A4%EC%9D%B4%EB%B2%84_%EA%B5%AD%EC%96%B4%EC%82%AC%EC%A0%84_%EC%98%81%EC%96%B4%EC%82%AC%EC%A0%84_%EA%B2%80%EC%83%89_%EB%8F%84%EA%B5%AC\"><\/span>5.1. Diccionario coreano Naver, herramienta de b\u00fasqueda de diccionarios en ingl\u00e9s<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es una herramienta automatizada que realiza b\u00fasquedas en los diccionarios de coreano e ingl\u00e9s de Naver e importa los resultados de la b\u00fasqueda a Excel. Esta herramienta puede ser de gran ayuda a la hora de crear palabras est\u00e1ndar y descripciones (definiciones) de t\u00e9rminos est\u00e1ndar durante el proceso de trabajo de estandarizaci\u00f3n de datos.&nbsp;<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/es\/naver-korean-english-dictionary-search-tool-overview\/\">Descripci\u00f3n general de la herramienta de b\u00fasqueda del diccionario Naver Korean Dictionary\/English Dictionary<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"571\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113-1024x571.png\" alt=\"\ub124\uc774\ubc84 \uad6d\uc5b4\uc0ac\uc804, \uc601\uc5b4\uc0ac\uc804 \uac80\uc0c9 \ub3c4\uad6c \ud654\uba74\" class=\"wp-image-11415\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113-1024x571.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113-300x167.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113-768x428.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113-36x20.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113-48x27.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Diccionario de coreano Naver, pantalla de herramienta de b\u00fasqueda de diccionario de ingl\u00e9s<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5.2._1\ucc28\uc6d0_Bin_Packing_\uc54c\uace0\ub9ac\uc998\uc744_\ud65c\uc6a9\ud55c_\uc791\uc5c5_\ubc30\ubd84_\ucd5c\uc801\ud654_\ub3c4\uad6c\"><span class=\"ez-toc-section\" id=\"52_1%EC%B0%A8%EC%9B%90_Bin_Packing_%EC%95%8C%EA%B3%A0%EB%A6%AC%EC%A6%98%EC%9D%84_%ED%99%9C%EC%9A%A9%ED%95%9C_%EC%9E%91%EC%97%85_%EB%B0%B0%EB%B6%84_%EC%B5%9C%EC%A0%81%ED%99%94_%EB%8F%84%EA%B5%AC\"><\/span>5.2. Herramienta de optimizaci\u00f3n de la asignaci\u00f3n de trabajo utilizando un algoritmo de empaque de contenedores unidimensional<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es una herramienta que implementa Next Fit, First Fit, Worst Fit y Best Fit, que son algoritmos de empaquetado de contenedores unidimensionales. Proporciona una forma de optimizar muchos elementos de trabajo con el objetivo de lograr la cantidad m\u00ednima de grupos de trabajo y el tiempo de ejecuci\u00f3n m\u00ednimo. Se puede utilizar para la ejecuci\u00f3n de tareas de conversi\u00f3n de datos (migraci\u00f3n) y la programaci\u00f3n de programas por lotes.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/es\/job-scheduling-using-1d-bin-packing-algorithm-toc\/\">Herramienta de optimizaci\u00f3n de la distribuci\u00f3n del trabajo utilizando un algoritmo de empaque de contenedores unidimensional. Contenido completo, Descargar<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-114.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"644\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-114-1024x644.png\" alt=\"1\ucc28\uc6d0 Bin Packing \ub3c4\uad6c \ud654\uba74\" class=\"wp-image-11416\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-114-1024x644.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-114-300x189.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-114-768x483.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-114-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-114-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-114-36x23.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-114-48x30.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-114.png 1482w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Pantalla de herramienta de embalaje de contenedores unidimensionales<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5.3._\ub370\uc774\ud130_\ud45c\uc900\uc810\uac80_\ub3c4\uad6c\"><span class=\"ez-toc-section\" id=\"53_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80_%EB%8F%84%EA%B5%AC\"><\/span>5.3. Herramienta de verificaci\u00f3n de est\u00e1ndares de datos<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es una herramienta que ayuda en el proceso de construcci\u00f3n de un diccionario de palabras est\u00e1ndar, dominios est\u00e1ndar y t\u00e9rminos est\u00e1ndar. Verificaci\u00f3n de est\u00e1ndares -&gt; Agregar palabra -&gt; Verificaci\u00f3n de est\u00e1ndares -&gt; Agregar dominio -&gt; Verificaci\u00f3n de est\u00e1ndares -&gt; Agregar t\u00e9rmino -&gt; Verificaci\u00f3n de est\u00e1ndares -&gt; Agregar palabra... Esto puede aumentar considerablemente la productividad cuando se realizan repetidamente comprobaciones est\u00e1ndar en una gran cantidad de nombres de atributos, como<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/es\/data-standard-checker-toc\/\">Herramienta de verificaci\u00f3n est\u00e1ndar de datos Descripci\u00f3n Contenido, Descargar<\/a><\/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-115.png\"><img loading=\"lazy\" decoding=\"async\" width=\"992\" height=\"588\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-115.png\" alt=\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c \ud654\uba74\" class=\"wp-image-11417\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-115.png 992w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-115-300x178.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-115-768x455.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-115-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-115-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-115-36x21.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-115-48x28.png 48w\" sizes=\"auto, (max-width: 992px) 100vw, 992px\" \/><\/a><figcaption>Pantalla de herramienta de verificaci\u00f3n de est\u00e1ndar de datos<\/figcaption><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"5.4._DA#_Macro_\ub3c4\uad6c\"><span class=\"ez-toc-section\" id=\"54_DA_Macro_%EB%8F%84%EA%B5%AC\"><\/span>5.4. Herramienta macro DA#<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es una herramienta macro que aumenta la utilizaci\u00f3n de DA#, una herramienta de modelado de datos dom\u00e9sticos. El DA# proporciona una excelente funci\u00f3n llamada &#039;edici\u00f3n por lotes&#039;, pero solo es posible en una unidad modelo. Esta herramienta permite que las funciones de recuperaci\u00f3n (Obtener), modificaci\u00f3n (Establecer) e inversi\u00f3n de informaci\u00f3n de entidad\/propiedad se procesen para m\u00faltiples modelos a la vez.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/es\/da-macro-toc\/\">Contenido de la descripci\u00f3n de la macro DA#, descarga<\/a><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-116.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"798\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-116-1024x798.png\" alt=\"DA# Macro \ub3c4\uad6c \ud654\uba74\" class=\"wp-image-11418\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-116-1024x798.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-116-300x234.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-116-768x599.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-116-15x12.png 15w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-116-24x19.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-116-36x28.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-116-48x37.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-116.png 1293w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>DA# Pantalla de herramientas de macros<\/figcaption><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"5.5._PowerDesigner_Macro_\ub3c4\uad6c\"><span class=\"ez-toc-section\" id=\"55_PowerDesigner_Macro_%EB%8F%84%EA%B5%AC\"><\/span>5.5. Herramienta Macro PowerDesigner<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es una herramienta PowerDesigner Macro que tiene algunas funciones de DA# Macro. PowerDesigner v15.6, que se utiliz\u00f3 en el momento de crear esta herramienta, no ten\u00eda una funci\u00f3n de &#039;edici\u00f3n por lotes&#039; para cada modelo.<\/p>\n\n\n\n<p>Hice la funci\u00f3n de &#039;edici\u00f3n por lotes&#039; con Excel VBA y la us\u00e9 bien, y planeo usarla nuevamente si es necesario en el futuro.<\/p>\n\n\n\n<p>Planeo publicar brevemente despu\u00e9s del lanzamiento de la macro DA#.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5.6._\ub370\uc774\ud130_\uc804\ud658(\uc774\ud589,_Migration)_\ub3c4\uad6c\"><span class=\"ez-toc-section\" id=\"56_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EC%A0%84%ED%99%98%EC%9D%B4%ED%96%89_Migration_%EB%8F%84%EA%B5%AC\"><\/span>5.6. Herramientas de migraci\u00f3n de datos (migraci\u00f3n)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es una herramienta que crea un programa de conversi\u00f3n\/verificaci\u00f3n (UNIX Shell) a partir de la definici\u00f3n de mapeo de columnas. Fue desarrollado con el prop\u00f3sito de generar autom\u00e1ticamente un programa de conversi\u00f3n\/verificaci\u00f3n cuando el dise\u00f1o de conversi\u00f3n de datos (definici\u00f3n de mapeo) se prepara de acuerdo con las reglas.<\/p>\n\n\n\n<p>Fue desarrollado en 2009 y se ha utilizado directamente en 5 proyectos de clientes, incluido el proyecto en ese momento. Hubo alrededor de 7 participantes que proporcionaron ideas para desarrollar esta herramienta o proporcionaron el c\u00f3digo fuente codificando directamente las funciones necesarias. Escuch\u00e9 que algunos de los participantes contin\u00faan usando esta herramienta hasta el d\u00eda de hoy, adapt\u00e1ndola a su propio uso. Entre las herramientas que desarroll\u00e9 yo mismo, esta herramienta me llev\u00f3 m\u00e1s tiempo y esfuerzo, y sent\u00ed el efecto en tiempo real mientras la hac\u00eda, por lo que estaba muy satisfecho conmigo mismo.<\/p>\n\n\n\n<p>Esta herramienta no est\u00e1 bien documentada, por lo que es necesario volver a abrir el c\u00f3digo fuente y documentar los conceptos y las descripciones de funciones. Poco a poco lo escribir\u00e9 y lo publicar\u00e9 en mi blog.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5.6._Excel_Data_Downloader\"><span class=\"ez-toc-section\" id=\"57_Excel_Data_Downloader\"><\/span>5.7. Descargador de datos de Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Esta es una herramienta que ejecuta consultas SQL en la base de datos y descarga los resultados como archivos de Excel. Defina m\u00faltiples bases de datos y m\u00faltiples consultas SQL por adelantado y haga clic en el bot\u00f3n &#039;Descargar&#039; para ejecutar cada consulta SQL en la base de datos y crear un archivo de Excel. Se utiliza para fines como la recopilaci\u00f3n de informaci\u00f3n de rendimiento de una base de datos y la descarga peri\u00f3dica de datos comerciales como un archivo de Excel.<\/p>\n\n\n\n<p>Esta herramienta tambi\u00e9n se publicar\u00e1 pronto.<\/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-117.png\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"665\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-117.png\" alt=\"Excel Data Downloader\" class=\"wp-image-11419\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-117.png 939w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-117-300x212.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-117-768x544.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-117-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-117-24x17.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-117-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-117-48x34.png 48w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/a><figcaption>Descargador de datos de Excel<\/figcaption><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"5.7._Excel_Data_Uploader\"><span class=\"ez-toc-section\" id=\"58_Excel_Data_Uploader\"><\/span>5.8. Cargador de datos de Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>A diferencia del &#039;Descargador de datos de Excel&#039; anterior, es una herramienta que carga archivos de Excel en la base de datos. La versi\u00f3n inicial fue creada por un junior en la empresa, y la estoy usando agregando las funciones necesarias.<\/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-118.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1025\" height=\"908\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-118.png\" alt=\"Excel Data Uploader\" class=\"wp-image-11420\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-118.png 1025w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-118-300x266.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-118-768x680.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-118-14x12.png 14w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-118-24x21.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-118-36x32.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-118-48x43.png 48w\" sizes=\"auto, (max-width: 1025px) 100vw, 1025px\" \/><\/a><figcaption>Cargador de datos de Excel<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>En este art\u00edculo, analizamos las herramientas desarrolladas y utilizadas en Excel VBA. Todas estas herramientas fueron desarrolladas por m\u00ed mismo cuando las necesitaba en el sitio del proyecto. Espero que sea de alguna ayuda para varios roles, como ingenieros que se ocupan de datos, arquitectos de datos y administradores de bases de datos.<\/p>\n\n\n\n<p>Despu\u00e9s de completar todas las conferencias de Excel VBA, publicar\u00e9 un art\u00edculo separado sobre los patrones de codificaci\u00f3n de VBA.<\/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\"><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><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-1-overview\/\">Curso Excel VBA(1): Descripci\u00f3n general de Excel VBA<\/a><\/li><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><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><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><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><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><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><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><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/\">Cursos de Excel VBA (9): Procedimientos de Excel VBA<\/a><\/li><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><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-toc\/\">Tabla de contenido completa para cursos de Excel VBA<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>En este art\u00edculo, miro ejemplos de herramientas que he desarrollado y usado con Excel VBA. Esta es una continuaci\u00f3n del art\u00edculo anterior. Clase de Excel VBA (9): Excel VBA How-To 5. Herramientas desarrolladas y utilizadas con Excel VBA 5.1. Naver Korean Dictionary, English Dictionary Search Tool Esta es una herramienta automatizada que busca en los diccionarios Naver de coreano e ingl\u00e9s e importa los resultados de la b\u00fasqueda a Excel.<\/p>","protected":false},"author":1,"featured_media":11415,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11413","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.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uc5d1\uc140 VBA \uac15\uc88c(10): \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\uc911\uc778 \ub3c4\uad6c - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\ub0b4\uac00 \uc9c1\uc811 \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \ub3c4\uad6c\uc758 \uc0ac\ub840\ub97c \uc0b4\ud3b4\ubcf8\ub2e4. \ub124\uc774\ubc84 \uad6d\uc5b4\uc0ac\uc804, \uc601\uc5b4\uc0ac\uc804 \uac80\uc0c9 \ub3c4\uad6c, 1\ucc28\uc6d0 Bin Packing \ub3c4\uad6c, \ub370\uc774\ud130 \ud45c\uc900 \uc810\uac80 \ub3c4\uad6c, DA# Macro \ub3c4\uad6c \ub4f1\uc744 \uc18c\uac1c\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-10-self-developed-tools\/\" \/>\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(10): \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\uc911\uc778 \ub3c4\uad6c - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\ub0b4\uac00 \uc9c1\uc811 \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \ub3c4\uad6c\uc758 \uc0ac\ub840\ub97c \uc0b4\ud3b4\ubcf8\ub2e4. \ub124\uc774\ubc84 \uad6d\uc5b4\uc0ac\uc804, \uc601\uc5b4\uc0ac\uc804 \uac80\uc0c9 \ub3c4\uad6c, 1\ucc28\uc6d0 Bin Packing \ub3c4\uad6c, \ub370\uc774\ud130 \ud45c\uc900 \uc810\uac80 \ub3c4\uad6c, DA# Macro \ub3c4\uad6c \ub4f1\uc744 \uc18c\uac1c\ud55c\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-10-self-developed-tools\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T13:32:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T02:43:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"714\" \/>\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=\"5 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-10-self-developed-tools\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(10): \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\uc911\uc778 \ub3c4\uad6c\",\"datePublished\":\"2022-09-11T13:32:13+00:00\",\"dateModified\":\"2022-10-11T02:43:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/\"},\"wordCount\":153,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png\",\"keywords\":[\"\uc5d1\uc140VBA\"],\"articleSection\":[\"\uc5d1\uc140 VBA \uac15\uc88c\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/\",\"url\":\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(10): \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\uc911\uc778 \ub3c4\uad6c - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png\",\"datePublished\":\"2022-09-11T13:32:13+00:00\",\"dateModified\":\"2022-10-11T02:43:18+00:00\",\"description\":\"\ub0b4\uac00 \uc9c1\uc811 \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \ub3c4\uad6c\uc758 \uc0ac\ub840\ub97c \uc0b4\ud3b4\ubcf8\ub2e4. \ub124\uc774\ubc84 \uad6d\uc5b4\uc0ac\uc804, \uc601\uc5b4\uc0ac\uc804 \uac80\uc0c9 \ub3c4\uad6c, 1\ucc28\uc6d0 Bin Packing \ub3c4\uad6c, \ub370\uc774\ud130 \ud45c\uc900 \uc810\uac80 \ub3c4\uad6c, DA# Macro \ub3c4\uad6c \ub4f1\uc744 \uc18c\uac1c\ud55c\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png\",\"width\":1280,\"height\":714},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(10): \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\uc911\uc778 \ub3c4\uad6c\"}]},{\"@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":"Curso de Excel VBA (10): Herramientas desarrolladas y utilizadas con Excel VBA - Habilidad de Productividad","description":"Veamos algunos ejemplos de herramientas que he desarrollado y utilizado con Excel VBA. Presentar\u00e9 las herramientas de b\u00fasqueda de diccionarios de coreano e ingl\u00e9s de Naver, la herramienta de empaquetado de contenedores unidimensional, la herramienta de verificaci\u00f3n de est\u00e1ndares de datos y la herramienta de macros DA#.","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-10-self-developed-tools\/","og_locale":"es_ES","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(10): \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\uc911\uc778 \ub3c4\uad6c - \uc0dd\uc0b0\uc131 Skill","og_description":"\ub0b4\uac00 \uc9c1\uc811 \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \ub3c4\uad6c\uc758 \uc0ac\ub840\ub97c \uc0b4\ud3b4\ubcf8\ub2e4. \ub124\uc774\ubc84 \uad6d\uc5b4\uc0ac\uc804, \uc601\uc5b4\uc0ac\uc804 \uac80\uc0c9 \ub3c4\uad6c, 1\ucc28\uc6d0 Bin Packing \ub3c4\uad6c, \ub370\uc774\ud130 \ud45c\uc900 \uc810\uac80 \ub3c4\uad6c, DA# Macro \ub3c4\uad6c \ub4f1\uc744 \uc18c\uac1c\ud55c\ub2e4.","og_url":"https:\/\/prodskill.com\/es\/excel-vba-lecture-10-self-developed-tools\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T13:32:13+00:00","article_modified_time":"2022-10-11T02:43:18+00:00","og_image":[{"width":1280,"height":714,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Zerom","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(10): \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\uc911\uc778 \ub3c4\uad6c","datePublished":"2022-09-11T13:32:13+00:00","dateModified":"2022-10-11T02:43:18+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/"},"wordCount":153,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png","keywords":["\uc5d1\uc140VBA"],"articleSection":["\uc5d1\uc140 VBA \uac15\uc88c"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/","name":"Curso de Excel VBA (10): Herramientas desarrolladas y utilizadas con Excel VBA - Habilidad de Productividad","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png","datePublished":"2022-09-11T13:32:13+00:00","dateModified":"2022-10-11T02:43:18+00:00","description":"Veamos algunos ejemplos de herramientas que he desarrollado y utilizado con Excel VBA. Presentar\u00e9 las herramientas de b\u00fasqueda de diccionarios de coreano e ingl\u00e9s de Naver, la herramienta de empaquetado de contenedores unidimensional, la herramienta de verificaci\u00f3n de est\u00e1ndares de datos y la herramienta de macros DA#.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-113.png","width":1280,"height":714},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c(10): \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\uc911\uc778 \ub3c4\uad6c"}]},{"@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\/11413","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=11413"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media\/11415"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media?parent=11413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/categories?post=11413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/tags?post=11413"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}