{"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\/en\/excel-vba-lecture-10-self-developed-tools\/","title":{"rendered":"Excel VBA Course (10): Tools developed and used with Excel VBA"},"content":{"rendered":"<p>This article looks at examples of tools that I developed with Excel VBA myself and are using.<\/p>\n\n\n\n<p>This is a continuation of the previous article.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/\">Excel VBA Courses (9): Excel VBA How-To<\/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;Table of Contents&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=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/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\/en\/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. Tools developed with 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\/en\/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. Naver Korean Dictionary, English Dictionary Search Tool<\/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\/en\/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. Work allocation optimization tool using one-dimensional bin packing algorithm<\/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\/en\/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. Data standard check tool<\/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\/en\/excel-vba-lecture-10-self-developed-tools\/#54_DA_Macro_%EB%8F%84%EA%B5%AC\" >5.4. DA# Macro Tool<\/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\/en\/excel-vba-lecture-10-self-developed-tools\/#55_PowerDesigner_Macro_%EB%8F%84%EA%B5%AC\" >5.5. PowerDesigner Macro tool<\/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\/en\/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. Data Migration (Migration) Tools<\/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\/en\/excel-vba-lecture-10-self-developed-tools\/#57_Excel_Data_Downloader\" >5.7. Excel Data Downloader<\/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\/en\/excel-vba-lecture-10-self-developed-tools\/#58_Excel_Data_Uploader\" >5.8. Excel Data Uploader<\/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. Tools developed with 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. Naver Korean Dictionary, English Dictionary Search Tool<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It is an automated tool that searches Naver Korean and English dictionaries and imports the search results into Excel. This tool can be of great help when creating standard words and descriptions (definitions) of standard terms during the data standardization work process.&nbsp;<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/naver-korean-english-dictionary-search-tool-overview\/\">Overview of Naver Korean Dictionary\/English Dictionary Search Tool<\/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>Naver Korean dictionary, English dictionary search tool screen<\/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. Work allocation optimization tool using one-dimensional bin packing algorithm<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It is a tool that implements the one-dimensional bin packing algorithm, Next Fit, First Fit, Worst Fit, and Best Fit. It provides a way to optimize many work items with the goal of the minimum number of work groups and the minimum execution time. It can be used for data conversion (migration) job execution and batch program scheduling.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/job-scheduling-using-1d-bin-packing-algorithm-toc\/\">Work distribution optimization tool using one-dimensional bin packing algorithm Full Contents, Download<\/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>One-dimensional Bin Packing tool screen<\/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. Data standard check tool<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It is a tool that helps in the process of building a dictionary of standard words, standard domains, and standard terms. Standards Check -&gt; Add Word -&gt; Standards Check -&gt; Add Domain -&gt; Standards Check -&gt; Add Term -&gt; Standards Check -&gt; Add Word... This can greatly increase productivity when repeatedly performing standard checks on a large number of attribute names, such as<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/data-standard-checker-toc\/\">Data Standard Check Tool Description Contents , Download<\/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>Data standard check tool screen<\/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. DA# Macro Tool<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It is a macro tool that increases the utilization of DA#, a domestic data modeling tool. The DA# provides a great function called &#039;batch editing&#039;, but it is possible only in one model unit. This tool enables entity\/property information retrieval (Get), modification (Set), and reverse functions to be processed for multiple models at once.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/da-macro-toc\/\">DA# Macro Description Contents , Download<\/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# Macro tool screen<\/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. PowerDesigner Macro tool<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It is a PowerDesigner Macro tool that has some functions of DA# Macro. PowerDesigner v15.6, which was used at the time of making this tool, did not have a model unit &#039;batch editing&#039; function.<\/p>\n\n\n\n<p>I made the &#039;batch editing&#039; function with Excel VBA and used it well, and I plan to use it again if needed in the future.<\/p>\n\n\n\n<p>After the release of the DA# Macro, I will post it briefly.<\/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. Data Migration (Migration) Tools<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It is a tool that creates a conversion\/verification program (UNiX Shell) from a column mapping definition. It was developed for the purpose of automatically creating a conversion\/verification program when the data conversion design (mapping definition) is written according to the rules.<\/p>\n\n\n\n<p>It was developed in 2009 and has been directly used in 5 customer projects since that time including the project. There were about 7 participants who provided ideas for developing this tool or provided the source code by directly coding the necessary functions. Some of the participants were told that they continue to use the tool to this day, adapting it to their own uses. Among the tools I developed myself, this tool took the most time and effort to make, and I was satisfied with myself as I felt the effect in real time while making it.<\/p>\n\n\n\n<p>This tool is not well documented, so it is necessary to open the source code again and to document the concept and function description. I will write it slowly and post it on my 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. Excel Data Downloader<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This is a tool that executes SQL queries in the database and downloads the results as Excel files. Define multiple databases and multiple SQL queries in advance and click the &#039;Download&#039; button to execute each SQL query in the database in turn and create an Excel file. It is used for purposes such as collecting performance information from a database and periodically downloading business data as an Excel file.<\/p>\n\n\n\n<p>This tool will also be posted on the blog soon.<\/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>Excel Data Downloader<\/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. Excel Data Uploader<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Contrary to the &#039;Excel Data Downloader&#039; above, it is a tool that uploads Excel files to the database. The initial version was created by a junior in the company, and I am using it by adding the necessary functions.<\/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>Excel Data Uploader<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>In this article, we looked at the tools developed with Excel VBA and used. All of these are tools I developed myself because I needed them at the project site. I hope that it will be of some help to various roles such as engineers who deal with data, data architects, and DBAs.<\/p>\n\n\n\n<p>After completing all of the Excel VBA courses above, I will post in a separate article about VBA coding patterns, etc.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt; Related article list &gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-preface\/\">Start the Excel VBA course. (Lecture notice, feat. Why we recommend Excel VBA)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-1-overview\/\">Excel VBA Course(1): Overview of Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-2-basic\/\">Excel VBA Course (2): Excel VBA Basics<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-3-object-model\/\">Excel VBA Course (3): Excel Object Model<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-4-handling-object-model\/\">Excel VBA Course (4): Working with Excel Object Model<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">Excel VBA Course (5): Excel File Extension, VBE, Font Settings<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-6-variable\/\">Excel VBA Course (6): Excel VBA Language Basics - Variables<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-7-syntax\/\">Excel VBA Course (7): Excel VBA Language Basics - Syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-8-datatype\/\">Excel VBA Course (8): Excel VBA Language Basics - Data Types, Data Structures<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/\">Excel VBA Courses (9): Excel VBA How-To<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-10-self-developed-tools\/\">Excel VBA Course (10): Tools developed and used with Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-toc\/\">Full Table of Contents for Excel VBA Courses<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>In this article, I look at examples of tools that I have developed and used with Excel VBA. This is a continuation of the previous article. Excel VBA Lecture (9): Excel VBA How-To 5. Tools developed and used with Excel VBA 5.1. Naver Korean Dictionary, English Dictionary Search Tool This is an automated tool that searches Naver Korean and English dictionaries and imports the search results into 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.4 - 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\/en\/excel-vba-lecture-10-self-developed-tools\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\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\/en\/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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\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\":\"en-US\",\"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\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-10-self-developed-tools\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\\\/en\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VBA Course (10): Tools developed and used with Excel VBA - Productivity Skill","description":"Let&#039;s take a look at some examples of tools I&#039;ve developed and used myself using Excel VBA. I&#039;ll introduce the Naver Korean and English dictionary search tools, the one-dimensional bin packing tool, the data standards check tool, and the DA# Macro tool.","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\/en\/excel-vba-lecture-10-self-developed-tools\/","og_locale":"en_US","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\/en\/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":{"Written by":"Zerom","Est. reading time":"5 minutes"},"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":"en-US","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":"Excel VBA Course (10): Tools developed and used with Excel VBA - Productivity 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":"Let&#039;s take a look at some examples of tools I&#039;ve developed and used myself using Excel VBA. I&#039;ll introduce the Naver Korean and English dictionary search tools, the one-dimensional bin packing tool, the data standards check tool, and the DA# Macro tool.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@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":"Productivity Skills","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":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@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\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11413"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11415"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}