{"id":11364,"date":"2022-09-11T16:29:56","date_gmt":"2022-09-11T07:29:56","guid":{"rendered":"https:\/\/prodskill.com\/?p=11364"},"modified":"2022-10-11T11:41:19","modified_gmt":"2022-10-11T02:41:19","slug":"excel-vba-lecture-6-variable","status":"publish","type":"post","link":"https:\/\/prodskill.com\/ja\/excel-vba-lecture-6-variable\/","title":{"rendered":"Excel VBA\u30b3\u30fc\u30b9\uff086\uff09\uff1aExcel VBA\u8a00\u8a9e\u57fa\u672c - \u5909\u6570"},"content":{"rendered":"\n<p>\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \ubcc0\uc218\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc804&nbsp;\uae00\uc5d0\uc11c&nbsp;\uc774\uc5b4\uc9c0\ub294&nbsp;\ub0b4\uc6a9\uc774\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">\uc5d1\uc140 VBA \uac15\uc88c(5): \uc5d1\uc140 \ud30c\uc77c \ud655\uc7a5\uc790, VBE, \uae00\uaf34 \uc124\uc815<\/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;\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\/ja\/excel-vba-lecture-6-variable\/#3_%EC%97%91%EC%85%80_VBA_%EC%96%B8%EC%96%B4_%EA%B8%B0%EB%B3%B8\" >3. \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8<\/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\/ja\/excel-vba-lecture-6-variable\/#31_%EB%B3%80%EC%88%98\" >3.1. \ubcc0\uc218<\/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\/ja\/excel-vba-lecture-6-variable\/#311_%EB%B3%80%EC%88%98_%EC%84%A0%EC%96%B8\" >3.1.1. \ubcc0\uc218 \uc120\uc5b8<\/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\/ja\/excel-vba-lecture-6-variable\/#312_%EB%B3%80%EC%88%98_Early_binding_Late_binding\" >3.1.2. \ubcc0\uc218 Early binding, Late binding<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"3._\uc5d1\uc140_VBA_\uc5b8\uc5b4_\uae30\ubcf8\"><span class=\"ez-toc-section\" id=\"3_%EC%97%91%EC%85%80_VBA_%EC%96%B8%EC%96%B4_%EA%B8%B0%EB%B3%B8\"><\/span>3. \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.1._\ubcc0\uc218\"><span class=\"ez-toc-section\" id=\"31_%EB%B3%80%EC%88%98\"><\/span>3.1. \ubcc0\uc218<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\ubcc0\uc218 \uc120\uc5b8\uacfc&nbsp; binding \ubc29\uc2dd\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.1._\ubcc0\uc218_\uc120\uc5b8\"><span class=\"ez-toc-section\" id=\"311_%EB%B3%80%EC%88%98_%EC%84%A0%EC%96%B8\"><\/span>3.1.1. \ubcc0\uc218 \uc120\uc5b8<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\ub2e4\uc74c\uacfc \uac19\uc740 \uad6c\ubb38\uc73c\ub85c \ubcc0\uc218\ub97c \uc120\uc5b8\ud55c\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=\"\">'\ubcc0\uc218 \uc120\uc5b8 \ubb38\ubc95\nDim &lt;\ubcc0\uc218\uba85> [As Type]<\/pre>\n\n\n\n<p>Visual Basic\uc740 \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\uc9c0 \uc54a\uace0 \ubc14\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uace0, \uc120\uc5b8\ud558\ub354\ub77c\ub3c4 Type\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p><\/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=\"\">Dim t, x<\/pre>\n\n\n\n<p>\uc704\uc640 \uac19\uc774 t\uc640 x \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\uba74\uc11c Type\uc740 \uc9c0\uc815\ud558\uc9c0 \uc54a\uc544\ub3c4 \ubb38\uc81c\uac00 \uc5c6\ub2e4.<\/p>\n\n\n\n<p>\ud558\uc9c0\ub9cc, \uc624\ub958\ub098 \ubc84\uadf8 \ubc1c\uc0dd \uac00\ub2a5\uc131\uc744 \uc904\uc774\uace0 \ucf54\ub4dc\ub97c \uc77d\uae30 \uc27d\uac8c \ud558\uae30 \uc704\ud558\uc5ec \ub2e4\uc74c\uacfc \uac19\uc740 \uc0ac\ud56d\uc744 \uc9c0\ud0a4\ub294 \uac83\uc774 \uc88b\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\ubcc0\uc218\ub294 \ubc18\ub4dc\uc2dc \uc120\uc5b8\ud558\uace0 \uc0ac\uc6a9\ud55c\ub2e4. (Option Explicit \uad8c\uc7a5)<\/li><li>Type\ub3c4 \ubc18\ub4dc\uc2dc \uc9c0\uc815\ud55c\ub2e4.<\/li><li>\ubcc0\uc218\uba85\uc5d0\ub294 type\uc744 \uc27d\uac8c \uc54c\uc544\ubcfc \uc218 \uc788\ub3c4\ub85d type\uc758 \uc57d\uc5b4\ub97c prefix\ub85c \uc0ac\uc6a9\ud558\ub294 \ud5dd\uac00\ub9ac\uc548 \ud45c\uae30\ubc95\uc744 \uc801\uc6a9\ud55c\ub2e4.<\/li><\/ul>\n\n\n\n<p><\/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=\"\">'\ubb38\uc790\uc5f4 Title\nDim sTitle As String<\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>\ubcc0\uc218\uba85, \ud504\ub85c\uc2dc\uc838\uba85, \ud568\uc218\uba85 \ub4f1\uc758 \uba85\uce6d\uc5d0 \ud55c\uae00\uc744 \uc0ac\uc6a9\ud574\ub3c4 \uc804\ud600 \ubb38\uc81c\uac00 \uc5c6\uc73c\ub2c8, \ubcc0\uc218\uba85\uc744 \uc815\ud558\uae30 \uc5b4\ub835\uac70\ub098 \uac00\ub3c5\uc131\uc744 \ub192\uc77c \ud544\uc694\uac00 \uc788\ub2e4\uba74 \ud55c\uae00 \uba85\uce6d\uc744 \uc801\uadf9 \uc0ac\uc6a9\ud55c\ub2e4.<\/li><\/ul>\n\n\n\n<p>\uc8fc\ub85c \uc0ac\uc6a9\ud558\ub294 type, prefix\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th>Prefix<\/th><th>Type<\/th><th>Length<\/th><th>\ucc38\uace0<\/th><\/tr><\/thead><tbody><tr><td>s<\/td><td>String<\/td><td>10&nbsp;+&nbsp;\ubb38\uc790\uc5f4\uae38\uc774<\/td><td>\uc57d&nbsp;20\uc5b5\uac1c\uc758&nbsp;\ubb38\uc790 \ud45c\ud604 \uac00\ub2a5<\/td><\/tr><tr><td>i<\/td><td>Integer<\/td><td>2 Byte<\/td><td>\ud55c\uacc4\uac12:&nbsp;-32,768&nbsp;~ 32,767<\/td><\/tr><tr><td>l<\/td><td>Long<\/td><td>4 Byte<\/td><td>\ud55c\uacc4\uac12:&nbsp;-2,147,483,648 ~ 2,147,483,647<\/td><\/tr><tr><td>b<\/td><td>Boolean<\/td><td>2 Byte<\/td><td>\ucc38(True),&nbsp;\uac70\uc9d3(False)<\/td><\/tr><tr><td>o<\/td><td>Object<\/td><td>&nbsp;<\/td><td>Workbook,&nbsp;Worksheet,&nbsp;Range,&nbsp;Collection&nbsp;\ub4f1\uc758 \uac1d\uccb4<\/td><\/tr><\/tbody><\/table><figcaption>Visual Basic \uc8fc\uc694 \ubcc0\uc218 type, prefix<\/figcaption><\/figure>\n\n\n\n<p>\uc704 Prefix\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\ub294 \uc608\uc2dc\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<p><\/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=\"\">Dim s\ub2e8\uc5b4 As String\nDim b\ub2e8\uc5b4\ubc1c\uacac As Boolean\nDim oTargetBook As Workbook\nDim oTargetSht As Worksheet<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.1.2._\ubcc0\uc218_Early_binding,_Late_binding\"><span class=\"ez-toc-section\" id=\"312_%EB%B3%80%EC%88%98_Early_binding_Late_binding\"><\/span>3.1.2. \ubcc0\uc218 Early binding, Late binding<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\ubcc0\uc218 type\uc774 \uc120\uc5b8\ud560 \ub54c \uc815\ud574\uc9c0\ub294 \ubc29\uc2dd\uc744 Early binding\uc774\ub77c\uace0 \ud558\uace0, \uc2e4\ud589\ud560 \ub54c \uc815\ud574\uc9c0\ub294 \ubc29\uc2dd\uc744 Late binding\uc774\ub77c\uace0 \ud55c\ub2e4. \ub450 \ubc29\uc2dd\uc758 \uac1c\ub150, \uc608\uc2dc, \uad8c\uc7a5\uc0ac\ud56d, \uc7a5\uc810, \ub2e8\uc810\uc744 \ub2e4\uc74c \ud45c\uc5d0 \uc815\ub9ac\ud558\uc600\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th>\uad6c\ubd84<\/th><th>Early binding<\/th><th>Late binding<\/th><\/tr><\/thead><tbody><tr><td>\uac1c\ub150<\/td><td>\ubcc0\uc218&nbsp;\uc120\uc5b8\uc2dc&nbsp;Type\uc744 \uc9c0\uc815\ud558\ub294 \ubc29\ubc95<br>\uae30\ubcf8 \uc81c\uacf5 Type\uc774 \uc544\ub2cc \uacbd\uc6b0 \ud574\ub2f9 Type\uc744 \ucc38\uc870 \ucd94\uac00\ud558\uace0 Type \uc9c0\uc815<\/td><td>\uc2e4\ud589\uc2dc&nbsp;Type\uc774 \uc9c0\uc815\ub418\ub294 \ubc29\ubc95<\/td><\/tr><tr><td>\uc608\uc2dc<\/td><td>Dim&nbsp;s\ub2e8\uc5b4&nbsp;As String<br>Dim&nbsp;oRecordSet&nbsp;As&nbsp;ADO.RecordSet<\/td><td>Dim&nbsp;s\ub2e8\uc5b4<br>Dim&nbsp;oRecordSet&nbsp;As Object<\/td><\/tr><tr><td>\uad8c\uc7a5\uc0ac\ud56d<\/td><td>\ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 \uad8c\uc7a5\ub428<\/td><td>\uaf2d \ud544\uc694\ud55c \uacbd\uc6b0\uc5d0\ub9cc \uc0ac\uc6a9<br>(Object type\uc5d0\ub9cc \ud55c\uc815)<\/td><\/tr><tr><td>\uc7a5\uc810<\/td><td>\ucf54\ub4dc \uc791\uc131\uc2dc \uc790\ub3d9\uc644\uc131,&nbsp;\ub3d9\uc801 \ub3c4\uc6c0\ub9d0 \uc9c0\uc6d0&nbsp;(\ud3b8\ub9ac)<br>\ucef4\ud30c\uc77c\uc2dc&nbsp;Type\uc774 \uacb0\uc815\ub418\ubbc0\ub85c \uc131\ub2a5\uc5d0 \uc720\ub9ac\ud568<\/td><td>\uc2e4\ud589\ud558\ub294 \ucef4\ud4e8\ud130\uc5d0 \ucc38\uc870&nbsp;Library\uac00 \uc5c6\uc73c\uba74&nbsp;Late&nbsp;binding\ub41c \ucf54\ub4dc \ubd80\ubd84\ub9cc&nbsp;\uc2e4\ud589 \ub418\uc9c0 \uc54a\uc74c<\/td><\/tr><tr><td>\ub2e8\uc810<\/td><td>\uc2e4\ud589\ud558\ub294 \ucef4\ud4e8\ud130\uc5d0 \ucc38\uc870&nbsp;Library\uac00 \uc5c6\uc73c\uba74 \uc804\uccb4\uac00 \uc2e4\ud589 \ub418\uc9c0 \uc54a\uc74c<\/td><td>\ucf54\ub4dc \uc791\uc131\uc2dc \uc790\ub3d9\uc644\uc131 \uc9c0\uc6d0 \uc548\ub428(\ubd88\ud3b8)<br>\uc2e4\ud589\uc2dc&nbsp;Type\uc774 \uacb0\uc815\ub418\uace0 \ub3d9\uc801\uc73c\ub85c&nbsp;binding&nbsp;\ub418\ubbc0\ub85c \uc131\ub2a5\uc774 \uc0c1\ub300\uc801\uc73c\ub85c \ub098\uc068<\/td><\/tr><\/tbody><\/table><figcaption>\ubcc0\uc218 Early binding, Late binding \ube44\uad50<\/figcaption><\/figure>\n\n\n\n<p>* \ucc38\uc870:&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/troubleshoot\/office-developer\/binding-type-available-to-automation-clients\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/troubleshoot\/office-developer\/binding-type-available-to-automation-clients<\/a><\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\uac01 \ubc29\uc2dd\uc758 \uc608\uc2dc \ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uc790. Outlook\uc73c\ub85c \uba54\uc77c\uc758 \uc218\uc2e0\uc790, \uc81c\ubaa9, \ub0b4\uc6a9\uc744 \uc791\uc131\ud558\uace0 \ud654\uba74\uc5d0 \ud45c\uc2dc\ud558\ub294 \uac04\ub2e8\ud55c \ucf54\ub4dc\uc774\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png\"><img loading=\"lazy\" decoding=\"async\" width=\"991\" height=\"462\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png\" alt=\"\" class=\"wp-image-11368\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png 991w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87-300x140.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87-768x358.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87-24x11.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87-36x17.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87-48x22.png 48w\" sizes=\"auto, (max-width: 991px) 100vw, 991px\" \/><\/a><figcaption>Early binding vs. Late binding \uc608\uc2dc \ucf54\ub4dc<\/figcaption><\/figure>\n\n\n\n<p>Early binding \ubc29\uc2dd\uc758 \uc608\uc2dc \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<p><\/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=\"\">Sub SendOLMail_EarlyBound()\n    \u200b\u200b\u200b\u200b\u200b' declare variables for the Application and Mailitem objects\n    \u200b\u200b\u200b\u200bDim oAPP                       As Outlook.Application\n    \u200b\u200b\u200b\u200bDim oItem                      As Outlook.MailItem\n    \u00a0\n    \u200b\u200b\u200b\u200b\u200b' instantiate the Application\n    \u200b\u200b\u200b\u200bSet oAPP = New Outlook.Application\n    \u00a0\n    \u200b\u200b\u200b\u200b\u200b' create a new email\n    \u200b\u200b\u200b\u200bSet oItem = oAPP.CreateItem(olMailItem)\n    \u00a0\n    \u200b\u200b\u200b\u200b\u200b' set basic properties and display the email\n    \u200b\u200b\u200b\u200bWith oItem\n        \u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b.To = \"foo@bar.com\"\n        \u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b.Subject = \"this is a test\"\n        \u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b.Body = \"nothing to see here\"\n        \u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b.Display\n    \u200b\u200b\u200b\u200b\u200bEnd With\nEnd Sub<\/pre>\n\n\n\n<p>oApp, oItem \ubcc0\uc218\ub294 \uac01\uac01 Outlook.Application type, Outlook.MailItem type\uc73c\ub85c \uc120\uc5b8\uc2dc \uc9c0\uc815\ub418\uc5c8\ub2e4. \uc774 \uacbd\uc6b0\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 Outlook library\ub97c \ucc38\uc870 \ucd94\uac00\ud574 \uc918\uc57c \ud55c\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\/09\/image-88.png\"><img loading=\"lazy\" decoding=\"async\" width=\"524\" height=\"338\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-88.png\" alt=\"\ud544\uc694\ud55c type library \ucc38\uc870 \ucd94\uac00\" class=\"wp-image-11369\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-88.png 524w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-88-300x194.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-88-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-88-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-88-36x23.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-88-48x31.png 48w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/a><figcaption>\ud544\uc694\ud55c type library \ucc38\uc870 \ucd94\uac00<\/figcaption><\/figure>\n<\/div>\n\n\n<p>&#8220;VBE &gt; \ub3c4\uad6c &gt; \ucc38\uc870&#8221; \uba54\ub274\ub97c \uc5f4\uace0 &#8220;\uc0ac\uc6a9 \uac00\ub2a5\ud55c \ucc38\uc870&#8221;\uc5d0\uc11c &#8220;Microsoft Outlook 16.0 Object Library&#8221;\uc5d0 \uccb4\ud06c \ud45c\uc2dc\ud558\uace0 \ud655\uc778 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n\n\n\n<p>\ub2e4\uc2dc \ucc38\uc870 \uba54\ub274\ub97c \uc5f4\uc5c8\uc744 \ub54c \ub2e4\uc74c\uacfc \uac19\uc774 \ub418\uc5b4\uc788\uc5b4\uc57c \ud55c\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\/09\/image-89.png\"><img loading=\"lazy\" decoding=\"async\" width=\"524\" height=\"338\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-89.png\" alt=\"type library \ucc38\uc870 \ucd94\uac00 \ud655\uc778\" class=\"wp-image-11370\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-89.png 524w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-89-300x194.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-89-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-89-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-89-36x23.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-89-48x31.png 48w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/a><figcaption>type library \ucc38\uc870 \ucd94\uac00 \ud655\uc778<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\uc774 VBA \ucf54\ub4dc\uac00 \uc800\uc7a5\ub41c \ub9e4\ud06c\ub85c \ud30c\uc77c(.xlsm, \ub610\ub294 .xlsb)\uc744 Outlook 16\uc774 \uc124\uce58\ub418\uc5b4 \uc788\uc9c0 \uc54a\uc740 PC\uc5d0 \ubcf5\uc0ac\ud558\uace0 \uc2e4\ud589\ud558\uba74 type\uc744 \ucc3e\uc744 \uc218 \uc5c6\ub2e4\ub294 \uc624\ub958\uac00 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Late binding \ubc29\uc2dd\uc758 \uc608\uc2dc \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n<p><\/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=\"\">Sub SendOLMail_LateBound()\n    \u200b\u200b\u200b\u200b\u200bDim oAPP                       As Object\n    \u200b\u200b\u200b\u200b\u200bDim oItem                      As Object\n    \u200b\u200b\u200b\u200b\u200b' need to declare this constant as it has no meaning without\n    \u200b\u200b\u200b\u200b' the reference set to the Outlook library\n    \u200b\u200b\u200b\u200bConst olMailItem               As Long = 0\n\n    \u200b\u200b\u200b\u200b\u200b' instantiate the Application - cannot use New without a reference\n    \u200b\u200b\u200b\u200b' so we must use CreateObject\n    \u200b\u200b\u200b\u200bSet oAPP = CreateObject(\"Outlook.Application\")\n\n    \u200b\u200b\u200b\u200b'\uc774\ud6c4 \ucf54\ub4dc\ub294 \ub3d9\uc77c\n    \u200b\u200b\u200b\u200b\u200b' create a new email\n    \u200b\u200b\u200b\u200bSet oItem = oAPP.CreateItem(olMailItem)\n\n    \u200b\u200b\u200b\u200b\u200b' set basic properties and display the email\n    \u200b\u200b\u200b\u200bWith oItem\n        \u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b.To = \"foo@bar.com\"\n        \u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b.Subject = \"this is a test\"\n        \u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b.Body = \"nothing to see here\"\n        \u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b\u200b.Display\n    \u200b\u200b\u200b\u200b\u200bEnd With\nEnd Sub<\/pre>\n\n\n\n<p>oApp, oItem \ubcc0\uc218\ub294 \uc120\uc5b8\uc2dc Object type\uc73c\ub85c \uc9c0\uc815\ub418\uc5c8\uace0, \uac1c\uccb4\ub97c \uc0dd\uc131\ud558\ub294 \ubc29\ubc95\uc774 \ub2e4\ub974\ub2e4.<\/p>\n\n\n\n<p>10\ubc88\uc9f8 \uc904 \ub2e4\uc74c \ucf54\ub4dc\ub85c \uac1c\uccb4\ub97c \uc0dd\uc131\ud55c\ub2e4.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Set oAPP = CreateObject(&#8220;Outlook.Application&#8221;)<\/p><\/blockquote>\n\n\n\n<p>CreateObject \ud568\uc218\uc5d0 \ub300\ud55c \uc0c1\uc138 \uc124\uba85\uc740 \ub2e4\uc74c URL\uc744 \ucc38\uc870\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/createobject-function\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/createobject-function<\/a><\/p>\n\n\n\n<p>\uc704 URL\uc5d0\uc11c \uc77c\ubd80\ub97c \ubc1c\ucdcc\ud558\uc5ec \ub0a8\uaca8\ub454\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p id=\"syntax\"><strong>Syntax<\/strong><\/p>\n\n\n\n<p><strong>CreateObject<\/strong>(class, [&nbsp;servername&nbsp;])<\/p>\n\n\n\n<p>The&nbsp;<strong>CreateObject<\/strong>&nbsp;function syntax has these parts:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Part<\/td><td>Description<\/td><\/tr><tr><td>class<\/td><td>Required;&nbsp;<strong>Variant<\/strong>&nbsp;(<strong>String<\/strong>). The application name and class of the object to create.<\/td><\/tr><tr><td>servername<\/td><td>Optional;&nbsp;<strong>Variant<\/strong>&nbsp;(<strong>String<\/strong>). The name of the network server where the object will be created. If&nbsp;servername&nbsp;is an empty string (&#8220;&#8221;), the local machine is used.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>The&nbsp;class&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/glossary\/vbe-glossary#argument\" target=\"_blank\" rel=\"noreferrer noopener\">argument<\/a>&nbsp;uses the syntax&nbsp;appname.objecttype&nbsp;and has these parts:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Part<\/td><td>Description<\/td><\/tr><tr><td>appname<\/td><td>Required;&nbsp;<strong>Variant<\/strong>&nbsp;(<strong>String<\/strong>). The name of the application providing the object.<\/td><\/tr><tr><td>objecttype<\/td><td>Required;&nbsp;<strong>Variant<\/strong>&nbsp;(<strong>String<\/strong>). The type or&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/glossary\/vbe-glossary#class\">class<\/a>&nbsp;of object to create.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\uc774 VBA \ucf54\ub4dc\uac00 \uc800\uc7a5\ub41c \ub9e4\ud06c\ub85c \ud30c\uc77c(.xlsm, \ub610\ub294 .xlsb)\uc744 Outlook 16\uc774 \uc124\uce58\ub418\uc5b4 \uc788\uc9c0 \uc54a\uc740 PC\uc5d0 \ubcf5\uc0ac\ud558\uace0 \uc2e4\ud589\ud558\uba74 Early binding\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c type\uc744 \ucc3e\uc744 \uc218 \uc5c6\ub2e4\ub294 \uc624\ub958\uac00 \ubc1c\uc0dd\ud55c\ub2e4. \ucc28\uc774\uc810\uc740, Early binding \ubc29\uc2dd\uc740 \ucc38\uc870 library\uac00 \uc5c6\uc73c\uba74 \ucc98\uc74c\ubd80\ud130 \ubaa8\ub4e0 \ucf54\ub4dc\uac00 \uc2e4\ud589\ub418\uc9c0 \uc54a\uace0, Late binding\uc740 \ub2e4\ub978 \ucf54\ub4dc\ub294 \ub3d9\uc791\ud558\uace0 CreateObject\uac00 \ud3ec\ud568\ub41c \ucf54\ub4dc(\ud504\ub85c\uc2dc\uc838, \ud568\uc218)\ub9cc \uc2e4\ud589\ub418\uc9c0 \uc54a\ub294\ub2e4\ub294 \uc810\uc774\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\uc5ec\uae30\uae4c\uc9c0 \ubcc0\uc218 \uc120\uc5b8\uacfc binding \ubc29\uc2dd\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uc558\ub2e4. \ub2e4\uc74c\uc5d0\ub294 VBA \uc5b8\uc5b4\uc758 \ubb38\ubc95(Syntax)\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uaca0\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt;&nbsp;\uad00\ub828 \uae00 \ubaa9\ub85d&nbsp;&gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-preface\/\">\uc5d1\uc140 VBA \uac15\uc88c\ub97c \uc2dc\uc791\ud569\ub2c8\ub2e4. (\uac15\uc88c\uc608\uace0, feat.\uc5d1\uc140 VBA\ub97c \uad8c\uc7a5\ud558\ub294 \uc774\uc720)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/\">\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/\">\uc5d1\uc140 VBA \uac15\uc88c(2): \uc5d1\uc140 VBA \uae30\ucd08<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/\">\uc5d1\uc140 VBA \uac15\uc88c(3): \uc5d1\uc140 Object Model<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/\">\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">\uc5d1\uc140 VBA \uac15\uc88c(5): \uc5d1\uc140 \ud30c\uc77c \ud655\uc7a5\uc790, VBE, \uae00\uaf34 \uc124\uc815<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/\">\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/\">\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/\">\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/\">\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/\">\uc5d1\uc140 VBA \uac15\uc88c(10): \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\uc911\uc778 \ub3c4\uad6c<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-toc\/\">\uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Excel VBA\u8a00\u8a9e\u306e\u57fa\u672c\u7684\u306a\u5909\u6570\u306e\u5185\u5bb9\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002\u524d\u306e\u8a18\u4e8b\u3067\u7d9a\u304f\u5185\u5bb9\u3060\u3002 Excel VBA\u30b3\u30fc\u30b9\uff085\uff09\uff1aExcel\u30d5\u30a1\u30a4\u30eb\u62e1\u5f35\u5b50\u3001VBE\u3001\u30d5\u30a9\u30f3\u30c8\u8a2d\u5b9a3. Excel VBA\u8a00\u8a9e\u306e\u57fa\u672c3.1\u3002\u5909\u6570\u5909\u6570\u5ba3\u8a00\u3068binding\u65b9\u5f0f\u306b\u3064\u3044\u3066\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002 3.1.1.\u5909\u6570\u5ba3\u8a00\u6b21\u306e\u69cb\u6587\u3067...<\/p>","protected":false},"author":1,"featured_media":11368,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11364","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-tutorial","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \ubcc0\uc218\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \ubcc0\uc218 \uc120\uc5b8\uc2dc Early binding(New \uc0ac\uc6a9), Late binding(CreateObject \uc0ac\uc6a9)\uc758 \uac1c\ub150\uacfc \ucc28\uc774, \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\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\/ja\/excel-vba-lecture-6-variable\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \ubcc0\uc218\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \ubcc0\uc218 \uc120\uc5b8\uc2dc Early binding(New \uc0ac\uc6a9), Late binding(CreateObject \uc0ac\uc6a9)\uc758 \uac1c\ub150\uacfc \ucc28\uc774, \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/ja\/excel-vba-lecture-6-variable\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T07:29:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T02:41:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png\" \/>\n\t<meta property=\"og:image:width\" content=\"991\" \/>\n\t<meta property=\"og:image:height\" content=\"462\" \/>\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=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"6\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218\",\"datePublished\":\"2022-09-11T07:29:56+00:00\",\"dateModified\":\"2022-10-11T02:41:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/\"},\"wordCount\":377,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png\",\"keywords\":[\"\uc5d1\uc140VBA\"],\"articleSection\":[\"\uc5d1\uc140 VBA \uac15\uc88c\"],\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/\",\"url\":\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png\",\"datePublished\":\"2022-09-11T07:29:56+00:00\",\"dateModified\":\"2022-10-11T02:41:19+00:00\",\"description\":\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \ubcc0\uc218\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \ubcc0\uc218 \uc120\uc5b8\uc2dc Early binding(New \uc0ac\uc6a9), Late binding(CreateObject \uc0ac\uc6a9)\uc758 \uac1c\ub150\uacfc \ucc28\uc774, \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png\",\"width\":991,\"height\":462},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218\"}]},{\"@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\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@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\/ja\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VBA\u30b3\u30fc\u30b9\uff086\uff09\uff1aExcel VBA\u8a00\u8a9e\u57fa\u672c - \u5909\u6570 - \u751f\u7523\u6027\u30b9\u30ad\u30eb","description":"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Excel VBA\u8a00\u8a9e\u306e\u57fa\u672c\u7684\u306a\u5909\u6570\u306e\u5185\u5bb9\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002\u5909\u6570\u5ba3\u8a00\u6642\u306eEarly binding\uff08New\u3092\u4f7f\u7528\uff09\u3001Late binding\uff08CreateObject\u3092\u4f7f\u7528\uff09\u306e\u6982\u5ff5\u3068\u9055\u3044\u3001\u4f8b\u306e\u30b3\u30fc\u30c9\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\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\/ja\/excel-vba-lecture-6-variable\/","og_locale":"ja_JP","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \ubcc0\uc218\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \ubcc0\uc218 \uc120\uc5b8\uc2dc Early binding(New \uc0ac\uc6a9), Late binding(CreateObject \uc0ac\uc6a9)\uc758 \uac1c\ub150\uacfc \ucc28\uc774, \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/ja\/excel-vba-lecture-6-variable\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T07:29:56+00:00","article_modified_time":"2022-10-11T02:41:19+00:00","og_image":[{"width":991,"height":462,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"Zerom","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"6\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218","datePublished":"2022-09-11T07:29:56+00:00","dateModified":"2022-10-11T02:41:19+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/"},"wordCount":377,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png","keywords":["\uc5d1\uc140VBA"],"articleSection":["\uc5d1\uc140 VBA \uac15\uc88c"],"inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/","name":"Excel VBA\u30b3\u30fc\u30b9\uff086\uff09\uff1aExcel VBA\u8a00\u8a9e\u57fa\u672c - \u5909\u6570 - \u751f\u7523\u6027\u30b9\u30ad\u30eb","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png","datePublished":"2022-09-11T07:29:56+00:00","dateModified":"2022-10-11T02:41:19+00:00","description":"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Excel VBA\u8a00\u8a9e\u306e\u57fa\u672c\u7684\u306a\u5909\u6570\u306e\u5185\u5bb9\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002\u5909\u6570\u5ba3\u8a00\u6642\u306eEarly binding\uff08New\u3092\u4f7f\u7528\uff09\u3001Late binding\uff08CreateObject\u3092\u4f7f\u7528\uff09\u306e\u6982\u5ff5\u3068\u9055\u3044\u3001\u4f8b\u306e\u30b3\u30fc\u30c9\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-87.png","width":991,"height":462},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"\u751f\u7523\u6027\u30b9\u30ad\u30eb","description":"\u30e1\u30bf\u30b7\u30f3\u30ad\u30f3\u30b0\u3001\u30e1\u30bf\u30ef\u30fc\u30af","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":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"ja","@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\/ja\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/posts\/11364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/comments?post=11364"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/posts\/11364\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/media\/11368"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/media?parent=11364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/categories?post=11364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/ja\/wp-json\/wp\/v2\/tags?post=11364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}