{"id":11694,"date":"2022-09-28T16:42:05","date_gmt":"2022-09-28T07:42:05","guid":{"rendered":"https:\/\/prodskill.com\/?p=11694"},"modified":"2022-10-10T21:01:58","modified_gmt":"2022-10-10T12:01:58","slug":"da-macro-function-common-entity-get-set","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/da-macro-function-common-entity-get-set\/","title":{"rendered":"DA# Macro(2): DA# Macro Function(1)-Common Function, Entity Get\/Set"},"content":{"rendered":"<p>In this article, Da# Macro common function Entity Get\/Set function will be reviewed.<\/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\/da-macro-overview\/\">DA# Macro(1): DA#, DA# API, DA# Macro Overview<\/a><\/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;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\/da-macro-function-common-entity-get-set\/#2_DA_Macro_%EA%B8%B0%EB%8A%A5\" >2. DA# Macro function<\/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\/da-macro-function-common-entity-get-set\/#21_DA_Macro_%EA%B3%B5%ED%86%B5_%EA%B8%B0%EB%8A%A5\" >2.1. DA# Macro Common Functions<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/da-macro-function-common-entity-get-set\/#211_Select_Model%EB%AA%A8%EB%8D%B8_%EC%84%A0%ED%83%9D\" >2.1.1. Select Model<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/da-macro-function-common-entity-get-set\/#212_Clear_List\" >2.1.2. Clear List<\/a><\/li><\/ul><\/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\/da-macro-function-common-entity-get-set\/#22_DA_Macro_Entity_GetSet\" >2.2. DA# Macro Entity Get\/Set<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/en\/da-macro-function-common-entity-get-set\/#221_Entity_Get\" >2.2.1. Entity Get<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/en\/da-macro-function-common-entity-get-set\/#222_Entity_Set\" >2.2.2. Entity Set<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"2._DA#_Macro_\uae30\ub2a5\"><span class=\"ez-toc-section\" id=\"2_DA_Macro_%EA%B8%B0%EB%8A%A5\"><\/span>2. DA# Macro function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>DA# Macro function is largely divided into common functions, Entity Get\/Set, Attribute Get\/Set, and Reverse.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.1._\uacf5\ud1b5_\uae30\ub2a5\"><span class=\"ez-toc-section\" id=\"21_DA_Macro_%EA%B3%B5%ED%86%B5_%EA%B8%B0%EB%8A%A5\"><\/span>2.1. DA# Macro Common Functions<span class=\"ez-toc-section-end\"><\/span><\/h3>\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-218.png\"><img loading=\"lazy\" decoding=\"async\" width=\"210\" height=\"36\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-218.png\" alt=\"DA# Macro: \uacf5\ud1b5\uae30\ub2a5 \ubc84\ud2bc\" class=\"wp-image-11695\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-218.png 210w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-218-18x3.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-218-24x4.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-218-36x6.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-218-48x8.png 48w\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" \/><\/a><figcaption>DA# Macro: Common Function Buttons<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Commonly applied to Entity(Get), Entity(Set), Attribute(Get), and Attribute(Set) sheets.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.1.1._Select_Model(\ubaa8\ub378_\uc120\ud0dd)\"><span class=\"ez-toc-section\" id=\"211_Select_Model%EB%AA%A8%EB%8D%B8_%EC%84%A0%ED%83%9D\"><\/span>2.1.1. Select Model<span class=\"ez-toc-section-end\"><\/span><\/h4>\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-219.png\"><img loading=\"lazy\" decoding=\"async\" width=\"695\" height=\"348\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-219.png\" alt=\"DA# Macro: \uacf5\ud1b5\uae30\ub2a5-Select Model\" class=\"wp-image-11696\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-219.png 695w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-219-300x150.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-219-18x9.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-219-24x12.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-219-36x18.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-219-48x24.png 48w\" sizes=\"auto, (max-width: 695px) 100vw, 695px\" \/><\/a><figcaption>DA# Macro: Common Function-Select Model<\/figcaption><\/figure>\n<\/div>\n\n\n<p>To execute the functions provided by each sheet, the \u201cSelect Model\u201d window must be running.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Add model file: Add model file to execute macro. You can select and add multiple files in one directory, or you can continue to add multiple files in another directory.<\/li><li>Add Open Model: If DA# is running, add the currently open model to DA#. You can also add models that have not yet been saved.<\/li><li>Save &amp; Close: This is an option to save and close when processing of one file is completed while executing Macro in turn for the model files added to the list. If checked, opens each file, processes it, saves it, and closes it. If it is not checked, it is opened and processed without saving. If there are many model files to process, keeping the model files open will consume a lot of memory, so it is recommended to check the \u201cSave &amp; Close\u201d option. The Get function operates only to close without saving.<\/li><li>Initialize List: Remove all model files added to the list.<\/li><li>Remove Selected Files: Removes only the selected files from the list. (Shift + Click to select multiple consecutive files, or Ctrl + Click to select and remove non-contiguous multiple files)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.1.2._Clear_List\"><span class=\"ez-toc-section\" id=\"212_Clear_List\"><\/span>2.1.2. Clear List<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>DA# Deletes the contents printed on the Excel sheet as a result of Macro execution.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.2._Entity_Get\/Set\"><span class=\"ez-toc-section\" id=\"22_DA_Macro_Entity_GetSet\"><\/span>2.2. DA# Macro Entity Get\/Set<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.2.1._Entity_Get\"><span class=\"ez-toc-section\" id=\"221_Entity_Get\"><\/span>2.2.1. Entity Get<span class=\"ez-toc-section-end\"><\/span><\/h4>\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-220.png\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"497\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.png\" alt=\"DA# Macro \uae30\ub2a5: Entity(Get)\" class=\"wp-image-11697\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.png 938w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220-300x159.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220-768x407.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220-48x25.png 48w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/a><figcaption>DA# Macro Function: Entity (Get)<\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\"><li>Get Entity: Opens the models selected in the \u201cSelect Model\u201d window one after another and brings the attribute information of all entities into Excel. At this time, only the attribute items selected in line 3 \u201cGet target by item (Y\/N)\u201d are imported. If the item is not absolutely necessary, you can set the target to \u201cN\u201d to speed up the execution time.<\/li><li>The attribute information of the entity imported into Excel is as follows.<ul><li>model name<\/li><li>entity name<\/li><li>table name<\/li><li>synonym<\/li><li>auxiliary name<\/li><li>DB Owner<\/li><li>Classification: One of Key, Main, Action, or None<\/li><li>Level<\/li><li>Stage: either essential or practical<\/li><li>Type: One of Normal, Additional, Drop, External, Pseudo<\/li><li>Standardization: one of inheritance, target, or non-target<\/li><li>situation<\/li><li>cycle of occurrence<\/li><li>monthly amount<\/li><li>Retention period (months)<\/li><li>total number of cases<\/li><li>Justice<\/li><li>data processing form<\/li><li>Uniqueness<\/li><li>Note<\/li><li>Tag<\/li><\/ul><\/li><li>Copy to Set: Copy the model name and entity name imported by \u201cGet Entity\u201d to the \u201cEntity(Set)\u201d sheet.<\/li><li>User Defined Property (UDP) values defined in entities You can import it by entering the UDP name in line 4 in . The UDP name must be entered correctly. If there is no UDP defined in the selected model or there is no matching UDP name, the UDP value is not imported.<\/li><li>Precautions<ul><li>The X column where the UDP entry begins must not be deleted.<\/li><li>UDP items after column Y can be added\/deleted and the order can be changed.<\/li><li>You cannot add\/delete\/reorder items in columns A to V and blank column W.<\/li><\/ul><\/li><\/ul>\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-221.png\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"497\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-221.png\" alt=\"DA# Macro \uae30\ub2a5: Entity(Get) - UDP\" class=\"wp-image-11698\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-221.png 938w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-221-300x159.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-221-768x407.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-221-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-221-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-221-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-221-48x25.png 48w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/a><figcaption>DA# Macro Function: Entity(Get) \u2013 UDP<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"2.2.2._Entity_Set\"><span class=\"ez-toc-section\" id=\"222_Entity_Set\"><\/span>2.2.2. Entity Set<span class=\"ez-toc-section-end\"><\/span><\/h4>\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-222.png\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"497\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-222.png\" alt=\"DA# Macro \uae30\ub2a5: Entity(Set)\" class=\"wp-image-11699\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-222.png 938w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-222-300x159.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-222-768x407.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-222-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-222-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-222-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-222-48x25.png 48w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/a><figcaption>DA# Macro Function: Entity (Set)<\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\"><li>Standard value: Select whether to find the target entity to be changed in column B (model name) by \u201centity name\u201d or \u201ctable name\u201d.<\/li><li>Append Mode: Appends the content written in the Excel sheet to the current value for \u201cDefinition\u201d, \u201cData processing type\u201d, \u201cSpecial item\u201d, and \u201cNote\u201d items among entity characteristics. It should be noted that this does not apply to all items.<\/li><li>Entity property information that can be changed is as follows. The properties &#039;classification&#039;, &#039;level&#039;, &#039;type&#039; and &#039;normalization&#039; must be written with one of the predefined values.<ul><li>entity name<\/li><li>table name<\/li><li>synonym<\/li><li>auxiliary name<\/li><li>DB Owner<\/li><li>Classification: One of Key, Main, Action, or None<\/li><li>Level<\/li><li>Stage: either essential or practical<\/li><li>Type: One of Normal, Additional, Drop, External, Pseudo<\/li><li>Standardization: one of inheritance, target, or non-target<\/li><li>situation<\/li><li>cycle of occurrence<\/li><li>monthly amount<\/li><li>Retention period (months)<\/li><li>total number of cases<\/li><li>Justice<\/li><li>data processing form<\/li><li>Uniqueness<\/li><li>Note<\/li><li>Tag<\/li><\/ul><\/li><li>Set Entity: Opens the models selected in the \u201cSelect Model\u201d window one after another and reflects the entity property information written in the Excel sheet to the model and the entity. Similar to the \u201cGet Entity\u201d function, only the attribute item selected in line 3 \u201cGet object by item (Y\/N)\u201d is reflected.<\/li><li>The entity UDP value to change is write in If the UDP name does not exactly match, the value is not reflected.<\/li><li>Precautions<ul><li>Column Z, where the UDP entry begins, must not be deleted.<\/li><li>UDP items after column Z can be added\/deleted and the order can be changed.<\/li><li>You cannot add\/delete\/reorder items in column A to column X and blank column Y.<\/li><\/ul><\/li><\/ul>\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-223.png\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"497\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-223.png\" alt=\"DA# Macro \uae30\ub2a5: Entity(Set) - UDP\" class=\"wp-image-11700\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-223.png 938w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-223-300x159.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-223-768x407.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-223-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-223-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-223-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-223-48x25.png 48w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/a><figcaption>DA# Macro Function: Entity(Set) \u2013 UDP<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>So far, we have looked at common functions and Entity Get\/Set functions among DA# Macro functions. Next, we will look at the Attribute Get\/Set function.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>&lt;&lt;&nbsp;<strong>List of related articles<\/strong>&nbsp;&gt;&gt;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/en\/da-macro-overview\/\">DA# Macro(1): DA#, DA# API, DA# Macro Overview<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/da-macro-function-common-entity-get-set\/\">DA# Macro(2): DA# Macro Function(1)-Common Function, Entity Get\/Set<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/da-macro-function-attribute-get-set\/\">DA# Macro(3): DA# Macro Function(2)-Attribute Get\/Set<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/da-macro-function-reverse\/\">DA# Macro(4): DA# Macro Function(3)-Reverse<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/da-macro-usage-notes\/\">DA# Macro(5): Usage notes\/notes, downloads, features to be added in the future, notes<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/da-macro-modeler-api\/\">DA# Macro(6): DA# Modeler API<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/da-macro-demo-video-youtube\/\">DA# Macro function demonstration video (YouTube)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/da-macro-toc\/\">DA# Macro Description Contents , Download<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>In this article, we look at the Da# Macro common function Entity Get\/Set function. This is a continuation of the previous article. DA# Macro(1): DA#, DA# API, DA# Macro (Macro) Overview 2. DA# Macro Function DA# Macro function is largely divided into common functions, Entity Get\/Set, Attribute Get\/Set, and Reverse. 2.1. DA# Macro common function...<\/p>","protected":false},"author":1,"featured_media":11697,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[17,73,109,110,111],"class_list":["post-11694","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-da-macro","tag-vba","tag-excel-vba","tag-da","tag-api","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(2): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(1)-\uacf5\ud1b5\uae30\ub2a5, Entity Get\/Set - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"Da# Macro \uacf5\ud1b5\uae30\ub2a5 Entity Get\/Set \uae30\ub2a5\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uacf5\ud1b5\uae30\ub2a5\uc740 Select Model(\ubaa8\ub378 \uc120\ud0dd), Clear List\ub85c \uc81c\uacf5\ub418\uace0, Entity Get\/Set \uae30\ub2a5\uc740 \uc120\ud0dd\ud55c \ubaa8\ub378\uc758 \uc5d4\ud130\ud2f0 \ud2b9\uc131\uc815\ubcf4\ub97c \uac00\uc838\uc624\uac70\ub098 \uc124\uc815\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\/da-macro-function-common-entity-get-set\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DA# Macro(2): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(1)-\uacf5\ud1b5\uae30\ub2a5, Entity Get\/Set - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"Da# Macro \uacf5\ud1b5\uae30\ub2a5 Entity Get\/Set \uae30\ub2a5\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uacf5\ud1b5\uae30\ub2a5\uc740 Select Model(\ubaa8\ub378 \uc120\ud0dd), Clear List\ub85c \uc81c\uacf5\ub418\uace0, Entity Get\/Set \uae30\ub2a5\uc740 \uc120\ud0dd\ud55c \ubaa8\ub378\uc758 \uc5d4\ud130\ud2f0 \ud2b9\uc131\uc815\ubcf4\ub97c \uac00\uc838\uc624\uac70\ub098 \uc124\uc815\ud55c\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/da-macro-function-common-entity-get-set\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-28T07:42:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-10T12:01:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.png\" \/>\n\t<meta property=\"og:image:width\" content=\"938\" \/>\n\t<meta property=\"og:image:height\" content=\"497\" \/>\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\/da-macro-function-common-entity-get-set\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"DA# Macro(2): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(1)-\uacf5\ud1b5\uae30\ub2a5, Entity Get\/Set\",\"datePublished\":\"2022-09-28T07:42:05+00:00\",\"dateModified\":\"2022-10-10T12:01:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/\"},\"wordCount\":314,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.png\",\"keywords\":[\"\uc5d1\uc140VBA\",\"Excel VBA\",\"DA#\",\"API\",\"DA# Macro\"],\"articleSection\":[\"DA# Macro\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/\",\"url\":\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/\",\"name\":\"DA# Macro(2): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(1)-\uacf5\ud1b5\uae30\ub2a5, Entity Get\/Set - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.png\",\"datePublished\":\"2022-09-28T07:42:05+00:00\",\"dateModified\":\"2022-10-10T12:01:58+00:00\",\"description\":\"Da# Macro \uacf5\ud1b5\uae30\ub2a5 Entity Get\/Set \uae30\ub2a5\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uacf5\ud1b5\uae30\ub2a5\uc740 Select Model(\ubaa8\ub378 \uc120\ud0dd), Clear List\ub85c \uc81c\uacf5\ub418\uace0, Entity Get\/Set \uae30\ub2a5\uc740 \uc120\ud0dd\ud55c \ubaa8\ub378\uc758 \uc5d4\ud130\ud2f0 \ud2b9\uc131\uc815\ubcf4\ub97c \uac00\uc838\uc624\uac70\ub098 \uc124\uc815\ud55c\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.png\",\"width\":938,\"height\":497},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DA# Macro(2): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(1)-\uacf5\ud1b5\uae30\ub2a5, Entity Get\/Set\"}]},{\"@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":"DA# Macro(2): DA# Macro Function (1) - Common Function, Entity Get\/Set - Productivity Skill","description":"Let&#039;s take a look at the Da# Macro common functions, Entity Get\/Set. Common functions include Select Model and Clear List, and the Entity Get\/Set function retrieves or sets entity attribute information for the selected model.","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\/da-macro-function-common-entity-get-set\/","og_locale":"en_US","og_type":"article","og_title":"DA# Macro(2): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(1)-\uacf5\ud1b5\uae30\ub2a5, Entity Get\/Set - \uc0dd\uc0b0\uc131 Skill","og_description":"Da# Macro \uacf5\ud1b5\uae30\ub2a5 Entity Get\/Set \uae30\ub2a5\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uacf5\ud1b5\uae30\ub2a5\uc740 Select Model(\ubaa8\ub378 \uc120\ud0dd), Clear List\ub85c \uc81c\uacf5\ub418\uace0, Entity Get\/Set \uae30\ub2a5\uc740 \uc120\ud0dd\ud55c \ubaa8\ub378\uc758 \uc5d4\ud130\ud2f0 \ud2b9\uc131\uc815\ubcf4\ub97c \uac00\uc838\uc624\uac70\ub098 \uc124\uc815\ud55c\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/da-macro-function-common-entity-get-set\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-28T07:42:05+00:00","article_modified_time":"2022-10-10T12:01:58+00:00","og_image":[{"width":938,"height":497,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.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\/da-macro-function-common-entity-get-set\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"DA# Macro(2): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(1)-\uacf5\ud1b5\uae30\ub2a5, Entity Get\/Set","datePublished":"2022-09-28T07:42:05+00:00","dateModified":"2022-10-10T12:01:58+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/"},"wordCount":314,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.png","keywords":["\uc5d1\uc140VBA","Excel VBA","DA#","API","DA# Macro"],"articleSection":["DA# Macro"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/","url":"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/","name":"DA# Macro(2): DA# Macro Function (1) - Common Function, Entity Get\/Set - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.png","datePublished":"2022-09-28T07:42:05+00:00","dateModified":"2022-10-10T12:01:58+00:00","description":"Let&#039;s take a look at the Da# Macro common functions, Entity Get\/Set. Common functions include Select Model and Clear List, and the Entity Get\/Set function retrieves or sets entity attribute information for the selected model.","breadcrumb":{"@id":"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-220.png","width":938,"height":497},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/da-macro-function-common-entity-get-set\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"DA# Macro(2): DA# Macro(\ub9e4\ud06c\ub85c) \uae30\ub2a5(1)-\uacf5\ud1b5\uae30\ub2a5, Entity Get\/Set"}]},{"@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\/11694","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=11694"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11694\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11697"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}