{"id":12286,"date":"2022-12-17T15:56:32","date_gmt":"2022-12-17T06:56:32","guid":{"rendered":"https:\/\/prodskill.com\/?p=12286"},"modified":"2022-12-17T15:59:36","modified_gmt":"2022-12-17T06:59:36","slug":"da-macro-v2-13","status":"publish","type":"post","link":"https:\/\/prodskill.com\/zh\/da-macro-v2-13\/","title":{"rendered":"DA# Macro_v2.13_20221217\u90e8\u7f72"},"content":{"rendered":"\n<p>Reverse \uad00\ub828 \ub450 \uac00\uc9c0 \uc624\ub958\ub97c \uc218\uc815\ud55c DA# Macro_v2.13_20221217 \ub97c \ubc30\ud3ec\ud55c\ub2e4. \uc218\uc815\ud55c \uc624\ub958\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>[Fix] Reverse: template\uc5d0 \uc9c0\uc815\ud55c Attribute \ud2b9\uc131 \uac12 \ubc00\ub9bc \uc218\uc815(\ud45c\uc900\ud654, \uc815\ubcf4\ubcf4\ud638\uc5ec\ubd80, \uc815\ubcf4\ubcf4\ud638\ub4f1\uae09, \uc554\ud638\ud654\uc5ec\ubd80, \uc2a4\ud06c\ub7a8\ube14)<\/li>\n\n\n\n<li>[Fix] Reverse: \uc815\ubcf4\ubcf4\ud638\ub4f1\uae09 \uac12 \uc124\uc815\ub418\uc9c0 \uc54a\ub294 \ubc84\uadf8 \uc218\uc815<\/li>\n<\/ul>\n\n\n\n<p>\ucc38\uace0\ub85c, DA# Macro \uc18c\uac1c\uae00(<a href=\"https:\/\/prodskill.com\/ko\/da-macro-overview\/\">DA# Macro(1): DA#, DA# API, DA# Macro (\ub9e4\ud06c\ub85c) \uac1c\uc694 &#8211; \uc0dd\uc0b0\uc131 Skill (prodskill.com)<\/a>)\uc740 v2.12\ub97c \uae30\uc900\uc73c\ub85c \uc124\uba85\ud588\uc5c8\ub2e4.<\/p>\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;\ubaa9\ucc28&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\/zh\/da-macro-v2-13\/#1_%EB%B2%84%EA%B7%B8_%ED%98%84%EC%83%81\" >1. \ubc84\uadf8 \ud604\uc0c1<\/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\/zh\/da-macro-v2-13\/#11_Reverse_template%EC%97%90_%EC%A7%80%EC%A0%95%ED%95%9C_Attribute_%ED%8A%B9%EC%84%B1_%EA%B0%92_%EB%B0%80%EB%A6%BC\" >1.1. Reverse template\uc5d0 \uc9c0\uc815\ud55c Attribute \ud2b9\uc131 \uac12 \ubc00\ub9bc<\/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\/zh\/da-macro-v2-13\/#12_Reverse_%EC%A0%95%EB%B3%B4%EB%B3%B4%ED%98%B8%EB%93%B1%EA%B8%89_%EA%B0%92_%EC%84%A4%EC%A0%95%EB%90%98%EC%A7%80_%EC%95%8A%EC%9D%8C\" >1.2. Reverse \uc815\ubcf4\ubcf4\ud638\ub4f1\uae09 \uac12 \uc124\uc815\ub418\uc9c0 \uc54a\uc74c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/zh\/da-macro-v2-13\/#2_%EC%88%98%EC%A0%95_%EB%82%B4%EC%9A%A9\" >2. \uc218\uc815 \ub0b4\uc6a9<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/zh\/da-macro-v2-13\/#21_Fix_Reverse_template%EC%97%90_%EC%A7%80%EC%A0%95%ED%95%9C_Attribute_%ED%8A%B9%EC%84%B1_%EA%B0%92_%EB%B0%80%EB%A6%BC_%EC%88%98%EC%A0%95\" >2.1. [Fix] Reverse template\uc5d0 \uc9c0\uc815\ud55c Attribute \ud2b9\uc131 \uac12 \ubc00\ub9bc \uc218\uc815<\/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\/zh\/da-macro-v2-13\/#22_Fix_Reverse_%EC%A0%95%EB%B3%B4%EB%B3%B4%ED%98%B8%EB%93%B1%EA%B8%89_%EA%B0%92_%EC%84%A4%EC%A0%95%EB%90%98%EC%A7%80_%EC%95%8A%EB%8A%94_%EB%B2%84%EA%B7%B8_%EC%88%98%EC%A0%95\" >2.2. [Fix] Reverse \uc815\ubcf4\ubcf4\ud638\ub4f1\uae09 \uac12 \uc124\uc815\ub418\uc9c0 \uc54a\ub294 \ubc84\uadf8 \uc218\uc815<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/zh\/da-macro-v2-13\/#3_DA_Macro_v213_20221217_%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C\" >3. DA# Macro_v2.13_20221217 \ub2e4\uc6b4\ub85c\ub4dc<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_%EB%B2%84%EA%B7%B8_%ED%98%84%EC%83%81\"><\/span>1. \ubc84\uadf8 \ud604\uc0c1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11_Reverse_template%EC%97%90_%EC%A7%80%EC%A0%95%ED%95%9C_Attribute_%ED%8A%B9%EC%84%B1_%EA%B0%92_%EB%B0%80%EB%A6%BC\"><\/span>1.1. Reverse: template\uc5d0 \uc9c0\uc815\ud55c Attribute \ud2b9\uc131 \uac12 \ubc00\ub9bc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>template \ud30c\uc77c\uc758 &#8220;Column&#8221; \uc2dc\ud2b8\uc5d0 \uc9c0\uc815\ud55c \uac12\uc774 \ud558\ub098\uc529 \ub4a4\ub85c \ubc00\ub824\uc11c \uc124\uc815\ub418\ub294 \ubc84\uadf8\uc774\ub2e4. \uc608\ub97c \ub4e4\uc5b4, template \ud30c\uc77c\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud55c \uacbd\uc6b0\uc5d0 \uc774 \ubc84\uadf8\uac00 \uc7ac\ud604\ub41c\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"448\" height=\"133\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png\" alt=\"template\uc5d0 \uc9c0\uc815\ud55c \uac12 \ubc00\ub9bc\" class=\"wp-image-12287\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png 448w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4-300x89.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4-18x5.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4-36x11.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4-48x14.png 48w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/a><figcaption class=\"wp-element-caption\">template\uc5d0 \uc9c0\uc815\ud55c \uac12 \ubc00\ub9bc<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\uac01 Attribute \ud2b9\uc131\uc5d0 \uc785\ub825\ud560 \uc218 \uc788\ub294 \uac12\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud45c\uc900\ud654: \uc815\ud574\uc9c4 \uac12 \uc911 \ud558\ub098\ub9cc \uc785\ub825 \uac00\ub2a5<\/li>\n\n\n\n<li>\uc815\ubcf4\ubcf4\ud638\uc5ec\ubd80: Y\/N \uc911 \ud558\ub098\ub9cc \uc785\ub825 \uac00\ub2a5<\/li>\n\n\n\n<li>\uc815\ubcf4\ubcf4\ud638\ub4f1\uae09: \ubb38\uc790\uc5f4<\/li>\n\n\n\n<li>\uc554\ud638\ud654\uc5ec\ubd80: Y\/N \uc911 \ud558\ub098\ub9cc \uc785\ub825 \uac00\ub2a5<\/li>\n\n\n\n<li>\uc2a4\ud06c\ub7a8\ube14: \ubb38\uc790\uc5f4<\/li>\n<\/ul>\n\n\n\n<p>\uc785\ub825\ud560 \uc218 \uc788\ub294 \uac12\uc774 \uac01\uac01 \ub2e4\ub974\uae30 \ub54c\ubb38\uc5d0, \ud558\ub098\uc529 \ubc00\ub9ac\uba74 \uc815\uc0c1\uc801\uc73c\ub85c \uc124\uc815\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"12_Reverse_%EC%A0%95%EB%B3%B4%EB%B3%B4%ED%98%B8%EB%93%B1%EA%B8%89_%EA%B0%92_%EC%84%A4%EC%A0%95%EB%90%98%EC%A7%80_%EC%95%8A%EC%9D%8C\"><\/span>1.2. Reverse: \uc815\ubcf4\ubcf4\ud638\ub4f1\uae09 \uac12 \uc124\uc815\ub418\uc9c0 \uc54a\uc74c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\uc704 \uc774\ubbf8\uc9c0\uc5d0\uc11c &#8220;\uc815\ubcf4\ubcf4\ud638\ub4f1\uae09&#8221; \uac12\uc744 \uc785\ub825\ud588\uc74c\uc5d0\ub3c4 \ub370\uc774\ud130 \ubaa8\ub378\uc5d0 \uac12\uc774 \uc124\uc815\ub418\uc9c0 \uc54a\ub294 \ubc84\uadf8\uc774\ub2e4. &#8220;\uc815\ubcf4\ubcf4\ud638\ub4f1\uae09&#8221; \uac12\uc744 Y\/N \uc911 \ud558\ub098\ub9cc \uc785\ub825 \uac00\ub2a5\ud558\ub3c4\ub85d \ub2e4\ub8e8\uace0 \uc788\uc5b4\uc11c \ubb38\uc790\uc5f4 \uac12\uc744 \ubb34\uc2dc\ud558\uace0 \uc785\ub825\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_%EC%88%98%EC%A0%95_%EB%82%B4%EC%9A%A9\"><\/span>2. \uc218\uc815 \ub0b4\uc6a9<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21_Fix_Reverse_template%EC%97%90_%EC%A7%80%EC%A0%95%ED%95%9C_Attribute_%ED%8A%B9%EC%84%B1_%EA%B0%92_%EB%B0%80%EB%A6%BC_%EC%88%98%EC%A0%95\"><\/span>2.1. [Fix] Reverse: template\uc5d0 \uc9c0\uc815\ud55c Attribute \ud2b9\uc131 \uac12 \ubc00\ub9bc \uc218\uc815<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>modDAConstType \ubaa8\ub4c8\uc758 \ubcc0\uacbd \uc804 \ucf54\ub4dc(\uc77c\ubd80 \ubc1c\ucdcc)\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">'----------------------------------------------------------------------------------------------------\n'Reverse Attribute property Index\nPublic Const DA_REVATTR_Sequence_IDX As Long = 0\nPublic Const DA_REVATTR_ModelName_IDX As Long = 1\nPublic Const DA_REVATTR_EntityName_IDX As Long = 2\nPublic Const DA_REVATTR_Name_IDX As Long = 3\n...\nPublic Const DA_REVATTR_Inclusive_IDX As Long = 27\nPublic Const DA_REVATTR_StandardType_IDX As Long = 28\nPublic Const DA_REVATTR_PrivacyAct_IDX As Long = 29\nPublic Const DA_REVATTR_PrivacyGrade_IDX As Long = 30\nPublic Const DA_REVATTR_Encryption_IDX As Long = 31\nPublic Const DA_REVATTR_EncryptionMethod_IDX As Long = 32<\/pre>\n\n\n\n<p>DA_REVATTR_Inclusive_IDX \ub97c \uc8fc\uc11d\ucc98\ub9ac\ud558\uace0 \uadf8 \uc774\ud6c4 \uc0c1\uc218\uac12\uc744 \ud558\ub098\uc529 \uc904\uc600\ub2e4. \uc774 \uc0c1\uc218\uac12\uc740 Reverse template \ud30c\uc77c &#8220;Column&#8221; sheet\uc758 \uceec\ub7fc \uc21c\ubc88\uc744 \ub098\ud0c0\ub0b8\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"8-13\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">'----------------------------------------------------------------------------------------------------\n'Reverse Attribute property Index\nPublic Const DA_REVATTR_Sequence_IDX As Long = 0\nPublic Const DA_REVATTR_ModelName_IDX As Long = 1\nPublic Const DA_REVATTR_EntityName_IDX As Long = 2\nPublic Const DA_REVATTR_Name_IDX As Long = 3\n...\n'Public Const DA_REVATTR_Inclusive_IDX As Long = 27 '2022-12-17 \uc8fc\uc11d \ucc98\ub9ac(Reverse\uc5d0\ub294 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub3c4\ub85d \ucc98\ub9ac\ud568)\nPublic Const DA_REVATTR_StandardType_IDX As Long = 27\nPublic Const DA_REVATTR_PrivacyAct_IDX As Long = 28\nPublic Const DA_REVATTR_PrivacyGrade_IDX As Long = 29\nPublic Const DA_REVATTR_Encryption_IDX As Long = 30\nPublic Const DA_REVATTR_EncryptionMethod_IDX As Long = 31<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"22_Fix_Reverse_%EC%A0%95%EB%B3%B4%EB%B3%B4%ED%98%B8%EB%93%B1%EA%B8%89_%EA%B0%92_%EC%84%A4%EC%A0%95%EB%90%98%EC%A7%80_%EC%95%8A%EB%8A%94_%EB%B2%84%EA%B7%B8_%EC%88%98%EC%A0%95\"><\/span>2.2. [Fix] Reverse: \uc815\ubcf4\ubcf4\ud638\ub4f1\uae09 \uac12 \uc124\uc815\ub418\uc9c0 \uc54a\ub294 \ubc84\uadf8 \uc218\uc815<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>CDAAttribute \ud074\ub798\uc2a4\uc758 SetValue \ud504\ub85c\uc2dc\uc838\uc5d0 \uc815\ubcf4\ubcf4\ud638\ub4f1\uae09 \uac12\uc744 GetBoolean \ud568\uc218\ub85c \ubcc0\ud658\ud558\uace0 \uc788\uc5c8\ub2e4. \uc815\ubcf4\ubcf4\ud638\ub4f1\uae09\uc740 Y\/N \uc73c\ub85c \uc124\uc815\ud558\ub294 \uac12\uc774 \uc544\ub2c8\uace0 \uc785\ub825\ud55c \ubb38\uc790\uc5f4\uc744 \uadf8\ub300\ub85c \uc124\uc815\ud574\uc57c \ud558\ub294\ub370 \ubd88\ud544\uc694\ud558\uac8c GetBoolean \ud568\uc218\ub97c \uc2e4\ud589\ud558\uc5ec \uac12\uc774 \uc124\uc815\ub418\uc9c0 \uc54a\uc558\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 \ucf54\ub4dc\ub97c \uc218\uc815\ud558\uc600\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">'DA# Attribute \uac1c\uccb4\uc5d0 \uac12 \uc124\uc815\nPublic Sub SetValue(ByRef aodAttribute As Modeler5.Attribute)\n    ....\n    '-- \ubcc0\uacbd \uc804 \ucf54\ub4dc\n    arrAttr(Modeler5.ATR_PRIVACYGRADE) = GetBoolean(Me.m_s\uc815\ubcf4\ubcf4\ud638\ub4f1\uae09)\n\n    '-- \ubcc0\uacbd \ud6c4 \ucf54\ub4dc\n    arrAttr(Modeler5.ATR_PRIVACYGRADE) = Me.m_s\uc815\ubcf4\ubcf4\ud638\ub4f1\uae09<\/pre>\n\n\n\n<p>\ucc38\uace0\ub85c, GetBoolean \ud568\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uad6c\ud604\ub418\uc5b4 \uc788\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">'Text(Y, N)\uc758 Boolean value \ubcc0\ud658(True, False)\nPublic Function GetBoolean(aValue As String) As Boolean\n    GetBoolean = IIf(UCase(Trim(aValue)) = \"Y\", True, False) 'Y=True, Else=False\nEnd Function<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_DA_Macro_v213_20221217_%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C\"><\/span>3. DA# Macro_v2.13_20221217 \ub2e4\uc6b4\ub85c\ub4dc<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\ubc84\uadf8\ub97c \uc218\uc815\ud55c \ubc84\uc804\uc744 github\uc5d0 \uc62c\ub824 \ub450\uc5c8\ub2e4. \uc544\ub798 URL\uc5d0\uc11c \ub2e4\uc6b4\ub85c\ub4dc\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/DAToolset\/DA-Macro\/raw\/main\/DA%23%20Macro_v2.13_20221217.xlsm\">https:\/\/github.com\/DAToolset\/DA-Macro\/raw\/main\/DA%23%20Macro_v2.13_20221217.xlsm<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5206\u53d1 DA# Macro_v2.13_20221217\uff0c\u7ea0\u6b63\u4e24\u4e2a\u4e0e\u53cd\u5411\u76f8\u5173\u7684\u9519\u8bef\u3002\u66f4\u6b63\u7684\u9519\u8bef\u662f\uff1a\u4f5c\u4e3a\u53c2\u8003\uff0cDA#\u5b8f\u4ecb\u7ecd\uff08DA#\u5b8f\uff081\uff09\uff1aDA#\uff0cDA# API\uff0cDA#\u5b8f\uff08\u5b8f\uff09\u6982\u8ff0-\u751f\u4ea7\u529b\u6280\u80fd\uff08prodskill.com\uff09\uff09\u662f\u57fa\u4e8ev2.12\u89e3\u91ca\u7684\u3002\u4e00\u3001Bug\u73b0\u8c61 1.1\uff0e\u53cd\u5411\uff1a\u5728\u6a21\u677f\u4e2d\u6307\u5b9a...<\/p>","protected":false},"author":1,"featured_media":12287,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[17,73,109,111],"class_list":["post-12286","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-da-macro","tag-vba","tag-excel-vba","tag-da","tag-da-macro"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DA# Macro_v2.13_20221217 \ubc30\ud3ec - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"Reverse \uad00\ub828 \ub450 \uac00\uc9c0 \uc624\ub958\ub97c \uc218\uc815\ud55c DA# Macro_v2.13_20221217 \ub97c \ubc30\ud3ec\ud55c\ub2e4. \uc218\uc815\ud55c \uc624\ub958\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4. 1. template\uc5d0 \uc9c0\uc815\ud55c Attribute \ud2b9\uc131 \uac12 \ubc00\ub9bc \uc218, 2.\uc815\ubcf4\ubcf4\ud638\ub4f1\uae09 \uac12 \uc124\uc815\ub418\uc9c0 \uc54a\ub294 \ubc84\uadf8 \uc218\uc815\" \/>\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\/zh\/da-macro-v2-13\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DA# Macro_v2.13_20221217 \ubc30\ud3ec - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"Reverse \uad00\ub828 \ub450 \uac00\uc9c0 \uc624\ub958\ub97c \uc218\uc815\ud55c DA# Macro_v2.13_20221217 \ub97c \ubc30\ud3ec\ud55c\ub2e4. \uc218\uc815\ud55c \uc624\ub958\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4. 1. template\uc5d0 \uc9c0\uc815\ud55c Attribute \ud2b9\uc131 \uac12 \ubc00\ub9bc \uc218, 2.\uc815\ubcf4\ubcf4\ud638\ub4f1\uae09 \uac12 \uc124\uc815\ub418\uc9c0 \uc54a\ub294 \ubc84\uadf8 \uc218\uc815\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/zh\/da-macro-v2-13\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-17T06:56:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-17T06:59:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"448\" \/>\n\t<meta property=\"og:image:height\" content=\"133\" \/>\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=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prodskill.com\/da-macro-v2-13\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-v2-13\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"DA# Macro_v2.13_20221217 \ubc30\ud3ec\",\"datePublished\":\"2022-12-17T06:56:32+00:00\",\"dateModified\":\"2022-12-17T06:59:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-v2-13\/\"},\"wordCount\":80,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-v2-13\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png\",\"keywords\":[\"\uc5d1\uc140VBA\",\"Excel VBA\",\"DA#\",\"DA# Macro\"],\"articleSection\":[\"DA# Macro\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/da-macro-v2-13\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/da-macro-v2-13\/\",\"url\":\"https:\/\/prodskill.com\/da-macro-v2-13\/\",\"name\":\"DA# Macro_v2.13_20221217 \ubc30\ud3ec - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-v2-13\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-v2-13\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png\",\"datePublished\":\"2022-12-17T06:56:32+00:00\",\"dateModified\":\"2022-12-17T06:59:36+00:00\",\"description\":\"Reverse \uad00\ub828 \ub450 \uac00\uc9c0 \uc624\ub958\ub97c \uc218\uc815\ud55c DA# Macro_v2.13_20221217 \ub97c \ubc30\ud3ec\ud55c\ub2e4. \uc218\uc815\ud55c \uc624\ub958\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4. 1. template\uc5d0 \uc9c0\uc815\ud55c Attribute \ud2b9\uc131 \uac12 \ubc00\ub9bc \uc218, 2.\uc815\ubcf4\ubcf4\ud638\ub4f1\uae09 \uac12 \uc124\uc815\ub418\uc9c0 \uc54a\ub294 \ubc84\uadf8 \uc218\uc815\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-v2-13\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/da-macro-v2-13\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/prodskill.com\/da-macro-v2-13\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png\",\"width\":448,\"height\":133},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/da-macro-v2-13\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DA# Macro_v2.13_20221217 \ubc30\ud3ec\"}]},{\"@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\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@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\/zh\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DA# Macro_v2.13_20221217 \u53d1\u5e03 - \u751f\u4ea7\u529b\u6280\u80fd","description":"DA# Macro_v2.13_20221217 \u5df2\u53d1\u5e03\uff0c\u4fee\u590d\u4e86\u4e0e\u201c\u53cd\u5411\u201d\u76f8\u5173\u7684\u4e24\u4e2a\u9519\u8bef\u3002\u4fee\u590d\u7684\u9519\u8bef\u5982\u4e0b\uff1a1. \u6a21\u677f\u4e2d\u6307\u5b9a\u7684\u5c5e\u6027\u503c\u6570\u91cf\u88ab\u63a8\u51fa\uff1b2. \u4fee\u590d\u4e86\u672a\u8bbe\u7f6e\u4fe1\u606f\u4fdd\u62a4\u7ea7\u522b\u503c\u7684\u9519\u8bef\u3002","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\/zh\/da-macro-v2-13\/","og_locale":"zh_CN","og_type":"article","og_title":"DA# Macro_v2.13_20221217 \ubc30\ud3ec - \uc0dd\uc0b0\uc131 Skill","og_description":"Reverse \uad00\ub828 \ub450 \uac00\uc9c0 \uc624\ub958\ub97c \uc218\uc815\ud55c DA# Macro_v2.13_20221217 \ub97c \ubc30\ud3ec\ud55c\ub2e4. \uc218\uc815\ud55c \uc624\ub958\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4. 1. template\uc5d0 \uc9c0\uc815\ud55c Attribute \ud2b9\uc131 \uac12 \ubc00\ub9bc \uc218, 2.\uc815\ubcf4\ubcf4\ud638\ub4f1\uae09 \uac12 \uc124\uc815\ub418\uc9c0 \uc54a\ub294 \ubc84\uadf8 \uc218\uc815","og_url":"https:\/\/prodskill.com\/zh\/da-macro-v2-13\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-12-17T06:56:32+00:00","article_modified_time":"2022-12-17T06:59:36+00:00","og_image":[{"width":448,"height":133,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"Zerom","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/da-macro-v2-13\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/da-macro-v2-13\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"DA# Macro_v2.13_20221217 \ubc30\ud3ec","datePublished":"2022-12-17T06:56:32+00:00","dateModified":"2022-12-17T06:59:36+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/da-macro-v2-13\/"},"wordCount":80,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/da-macro-v2-13\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png","keywords":["\uc5d1\uc140VBA","Excel VBA","DA#","DA# Macro"],"articleSection":["DA# Macro"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/da-macro-v2-13\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/da-macro-v2-13\/","url":"https:\/\/prodskill.com\/da-macro-v2-13\/","name":"DA# Macro_v2.13_20221217 \u53d1\u5e03 - \u751f\u4ea7\u529b\u6280\u80fd","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/da-macro-v2-13\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/da-macro-v2-13\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png","datePublished":"2022-12-17T06:56:32+00:00","dateModified":"2022-12-17T06:59:36+00:00","description":"DA# Macro_v2.13_20221217 \u5df2\u53d1\u5e03\uff0c\u4fee\u590d\u4e86\u4e0e\u201c\u53cd\u5411\u201d\u76f8\u5173\u7684\u4e24\u4e2a\u9519\u8bef\u3002\u4fee\u590d\u7684\u9519\u8bef\u5982\u4e0b\uff1a1. \u6a21\u677f\u4e2d\u6307\u5b9a\u7684\u5c5e\u6027\u503c\u6570\u91cf\u88ab\u63a8\u51fa\uff1b2. \u4fee\u590d\u4e86\u672a\u8bbe\u7f6e\u4fe1\u606f\u4fdd\u62a4\u7ea7\u522b\u503c\u7684\u9519\u8bef\u3002","breadcrumb":{"@id":"https:\/\/prodskill.com\/da-macro-v2-13\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/da-macro-v2-13\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/prodskill.com\/da-macro-v2-13\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/12\/image-4.png","width":448,"height":133},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/da-macro-v2-13\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"DA# Macro_v2.13_20221217 \ubc30\ud3ec"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"\u751f\u4ea7\u529b\u6280\u80fd","description":"\u5143\u601d\u7ef4\uff0c\u5143\u5de5\u4f5c","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":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"\u6cfd\u7f57\u59c6","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@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\/zh\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/12286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/comments?post=12286"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/12286\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media\/12287"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media?parent=12286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/categories?post=12286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/tags?post=12286"}],"curies":[{"name":"\u53ef\u6e7f\u6027\u7c89\u5242","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}