{"id":11344,"date":"2022-09-11T12:40:12","date_gmt":"2022-09-11T03:40:12","guid":{"rendered":"https:\/\/prodskill.com\/?p=11344"},"modified":"2022-10-11T11:40:26","modified_gmt":"2022-10-11T02:40:26","slug":"excel-vba-lecture-4-handling-object-model","status":"publish","type":"post","link":"https:\/\/prodskill.com\/de\/excel-vba-lecture-4-handling-object-model\/","title":{"rendered":"Excel VBA-Kurs (4): Arbeiten mit dem Excel-Objektmodell"},"content":{"rendered":"<p>In diesem Artikel werden wir uns mit dem Umgang mit dem Excel-Objektmodell befassen.<\/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;Inhaltsverzeichnis&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=\"Inhaltsverzeichnis umschalten\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Umschalten<\/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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-4-handling-object-model\/#24_%EA%B0%84%EB%8B%A8%ED%95%9C_%EC%BD%94%EB%93%9C%EB%A1%9C_%EC%97%91%EC%85%80_Object_Model_%EC%9D%B4%ED%95%B4%ED%95%98%EA%B8%B0\" >2.4. Verstehen des Excel-Objektmodells mit einfachem Code<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-4-handling-object-model\/#241_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%EA%B8%B0%EB%B3%B8%ED%98%95\" >2.4.1. Objektzugriffsprimitive<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-4-handling-object-model\/#242_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%EB%8B%A8%EC%88%9C%ED%98%95\" >2.4.2. einfacher Objektzugriff<\/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\/de\/excel-vba-lecture-4-handling-object-model\/#243_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%ED%99%9C%EC%9A%A9_%EC%98%88%EC%A0%9C\" >2.4.3. Beispiele f\u00fcr Objektzugriff und -nutzung<\/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\/de\/excel-vba-lecture-4-handling-object-model\/#25_%EC%97%91%EC%85%80_Object_Model_%EC%83%81%EC%84%B8\" >2.5. Details zum Excel-Objektmodell<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\" id=\"2.4._\uac04\ub2e8\ud55c_\ucf54\ub4dc\ub85c_\uc5d1\uc140_Object_Model_\uc774\ud574\ud558\uae30\"><span class=\"ez-toc-section\" id=\"24_%EA%B0%84%EB%8B%A8%ED%95%9C_%EC%BD%94%EB%93%9C%EB%A1%9C_%EC%97%91%EC%85%80_Object_Model_%EC%9D%B4%ED%95%B4%ED%95%98%EA%B8%B0\"><\/span>2.4. Verstehen des Excel-Objektmodells mit einfachem Code<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.4.1._\uac1d\uccb4_\uc811\uadfc_\uae30\ubcf8\ud615\"><span class=\"ez-toc-section\" id=\"241_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%EA%B8%B0%EB%B3%B8%ED%98%95\"><\/span>2.4.1. Objektzugriffsprimitive<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Sehen wir uns den grundlegendsten Code an, der auf Dateien, Bl\u00e4tter, Bereiche und Zellen zugreift. Als Referenz kann das globale Objekt Application beim Zugriff auf das Objekt weggelassen werden. In der zweiten Zeile jedes Beispiels von 1 bis 6 unten wird der Code ohne Anwendung ausgedr\u00fcckt.<\/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=\"\" data-no-auto-translation=\"\">'1. \uc774\ub984\uc774 t1.xlsx \uc778 \ud30c\uc77c\nApplication.Workbooks(\"t1.xlsx\")\nWorkbooks(\"t1.xlsx\") \n\n'2. \uc774 \ud30c\uc77c\uc758 Sheet1 \uc2dc\ud2b8\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\")\n\n'3. \uc774 \uc2dc\ud2b8\uc758 A1 cell\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\") \n\n'4. \uc774 \uc2dc\ud2b8\uc758 A1 cell \uc5d0 \"TEST\" \ubb38\uc790\uc5f4 \uc785\ub825\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\") = \"TEST\"\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\") = \"TEST\"\n\n'5. \uc774 \uc2dc\ud2b8\uc758 A1 cell \uae00\uaf34\uc744 \uad75\uac8c(Bold) \uc124\uc815\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\").Font.Bold = True\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\").Font.Bold = True\n\n'6. \uc774 \uc2dc\ud2b8\uc758 A2:D4 \ubc94\uc704\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A2:D4\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A2:D4\")<\/pre>\n\n\n\n<p>Schauen wir uns jeden genauer an.<\/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=\"\" data-no-auto-translation=\"\">'1. \uc774\ub984\uc774 t1.xlsx \uc778 \ud30c\uc77c\nApplication.Workbooks(\"t1.xlsx\")\nWorkbooks(\"t1.xlsx\")<\/pre>\n\n\n\n<p>\u25b2 Dies ist eine Syntax, die die Datei mit dem Namen \u201et1.xlsx\u201c unter den derzeit in Excel ge\u00f6ffneten Dateien angibt. Arbeitsmappen verwaltet eine Sammlung ge\u00f6ffneter Dateien. Greifen Sie bei der Auswahl einer von mehreren Dateien auf den \u201eDateinamen\u201c der Workbooks-Sammlung als Parameter zu. (Als Referenz kann neben dem Dateinamen auch die Reihenfolge, in der die Datei ge\u00f6ffnet wurde, z. B. \u201eWorkbooks(1)\u201c, als Parameter verwendet werden.)<\/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=\"\" data-no-auto-translation=\"\">'2. \uc774 \ud30c\uc77c\uc758 Sheet1 \uc2dc\ud2b8\nApplication. Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\")<\/pre>\n\n\n\n<p>\u25b2 Dies ist eine Syntax, die das \u201eSheet1\u201c-Blatt der oben angegebenen \u201et1.xlsx\u201c-Datei angibt. Arbeitsbl\u00e4tter verwalten eine Sammlung von Bl\u00e4ttern in einer Datei. Wenn Sie eines von mehreren Bl\u00e4ttern ausw\u00e4hlen, greifen Sie als Parameter auf den &#039;Blattnamen&#039; der Worksheets-Sammlung zu. (Wie bei Arbeitsmappen k\u00f6nnen Sie auch die Reihenfolge der Bl\u00e4tter als Parameter verwenden, z. B. \u201eArbeitsbl\u00e4tter (1)\u201c.)<\/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=\"\" data-no-auto-translation=\"\">'3. \uc774 \uc2dc\ud2b8\uc758 A1 cell\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\")<\/pre>\n\n\n\n<p>\u25b2 Dies ist ein Ausdruck, der die \u201eA1\u201c-Zelle des oben angegebenen \u201eSheet1\u201c-Blatts angibt.<\/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=\"\" data-no-auto-translation=\"\">'4. \uc774 \uc2dc\ud2b8\uc758 A1 cell \uc5d0 \"TEST\" \ubb38\uc790\uc5f4 \uc785\ub825\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\") = \"TEST\"\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\") = \"TEST\"<\/pre>\n\n\n\n<p>\u25b2 Dieser Code gibt einen Zeichenfolgenwert in die Zelle ein, auf die oben zugegriffen wurde. Sie k\u00f6nnen jeden Werttyp eingeben, einschlie\u00dflich Zeichenfolgen und Zahlen.<\/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=\"\" data-no-auto-translation=\"\">'5. \uc774 \uc2dc\ud2b8\uc758 A1 cell \uae00\uaf34\uc744 \uad75\uac8c(Bold) \uc124\uc815\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\").Font.Bold = True\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\").Font.Bold = True<\/pre>\n\n\n\n<p>\u25b2 Dieser Code legt das Zellenformat mithilfe des Range-Objekts fest. Alle Zellformate wie Schriftart, Farbe, Gr\u00f6\u00dfe, Hintergrundfarbe, Zellrahmentyp und Rahmenfarbe k\u00f6nnen mit VBA-Code festgelegt werden.<\/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=\"\" data-no-auto-translation=\"\">'6. \uc774 \uc2dc\ud2b8\uc758 A2:D4 \ubc94\uc704\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A2:D4\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A2:D4\")<\/pre>\n\n\n\n<p>\u25b2 Ein Range-Objekt kann auf mehrere zusammenh\u00e4ngende Zellen zeigen. Der Bereich (\u201eA2:D4\u201c) steht f\u00fcr \u201e2 Zeilen, 1 Spalte\u201c bis \u201e4 Zeilen, 4 Spalten\u201c.<\/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-75.png\"><img loading=\"lazy\" decoding=\"async\" width=\"356\" height=\"323\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75.png\" alt=\"Range(&quot;A2:D4&quot;)\" class=\"wp-image-11345\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75.png 356w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75-300x272.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75-13x12.png 13w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75-24x22.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75-36x33.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75-48x44.png 48w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/a><figcaption>Reichweite (&quot;A2:D4&quot;)<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"2.4.2._\uac1d\uccb4_\uc811\uadfc_\ub2e8\uc21c\ud615\"><span class=\"ez-toc-section\" id=\"242_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%EB%8B%A8%EC%88%9C%ED%98%95\"><\/span>2.4.2. einfacher Objektzugriff<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Wenn Sie auf die aktuelle Datei oder das aktuelle Blatt zugreifen, k\u00f6nnen Sie diese einfach wie folgt verwenden. Dieser Code ist einfach und gut lesbar, aber Vorsicht ist geboten, wenn die aktuelle Datei oder das Blatt w\u00e4hrend der Ausf\u00fchrung ge\u00e4ndert wird.<\/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=\"\" data-no-auto-translation=\"\">'1. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ud30c\uc77c\nActiveWorkbook\n\n'2. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\nActiveWorksheet\n\n'3. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc758 A1 cell\nRange(\"A1\")\nActiveWorksheet.Range(\"A1\")\n\n'4. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc758 A1 cell \uc5d0 \"TEST\" \ub77c\ub294 \uac12 \ud560\ub2f9\nRange(\"A1\") = \"TEST\"\n\n'5. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc758 \uc2dc\ud2b8\uc758 A1 cell \uae00\uaf34\uc744 \uad75\uac8c(Bold) \uc124\uc815\nRange(\"A1\").Font.Bold = True\n\n'6. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc758 A2:D4 \ubc94\uc704\nRange(\"A2:D4\")<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.4.3._\uac1d\uccb4_\uc811\uadfc_&amp;_\ud65c\uc6a9_\uc608\uc81c\"><span class=\"ez-toc-section\" id=\"243_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%ED%99%9C%EC%9A%A9_%EC%98%88%EC%A0%9C\"><\/span>2.4.3. Beispiele f\u00fcr Objektzugriff und -nutzung<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Sehen wir uns einige weitere Beispiele f\u00fcr den Zugriff auf Objekte an.<\/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=\"\" data-no-auto-translation=\"\">'1. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ud30c\uc77c\ub4e4\nWorkbooks\n\n'2. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ud30c\uc77c\ub4e4\uc758 \uc218\nWorkbooks.Count\n\n'3. \uc0c8\ub85c\uc6b4 \ud30c\uc77c \ub9cc\ub4e4\uae30\nWorkbooks.Add\n\n'4. \ud604\uc7ac \ud30c\uc77c\uc744 C:\\test.xlsx\ub85c \uc800\uc7a5\ud558\uae30\nActiveWorkbook.SaveAs \"C:\\test.xlsx\"\n\n'5. \ud604\uc7ac \ud30c\uc77c\uc758 \uc774\ub984\uc744 \ubcf4\uc5ec\uc8fc\uae30\nMsgBox ActiveWorkbook.Name\n\n'6. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ud30c\uc77c\uc758 \uc2dc\ud2b8\ub4e4\nWorksheets\n\n'7. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ud30c\uc77c\uc758 \uc2dc\ud2b8\ub4e4\uc758 \uc218\nWorksheets.Count\n\n'8. \uc0c8\ub85c\uc6b4 \uc2dc\ud2b8 \ub9cc\ub4e4\uae30\nWorksheets.Add\n\n'9. Sheet1\uc744 \uc0ad\uc81c\ud558\uae30\nWorksheets(\"Sheet1\").Delete\n\n'10. \ud604\uc7ac \uc2dc\ud2b8\uc758 \uc774\ub984\uc744 \ubcf4\uc5ec\uc8fc\uae30\nMsgBox ActiveSheet.Name\n\n'11. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc758 A1 cell \uc120\ud0dd\nRange(\"A1\").Select\n\n'12. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ub41c \uc601\uc5ed\uc744 \uc120\ud0dd\nActiveSheet.UsedRange.Select<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.5._\uc5d1\uc140_Object_Model_\uc0c1\uc138\"><span class=\"ez-toc-section\" id=\"25_%EC%97%91%EC%85%80_Object_Model_%EC%83%81%EC%84%B8\"><\/span>2.5. Details zum Excel-Objektmodell<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Die hierarchische Struktur des h\u00e4ufig verwendeten Excel-Objektmodells ist wie folgt. Die in dieser Abbildung gezeigten Objekte sind ein Teil, nicht das Ganze, das f\u00fcr Excel VBA bereitgestellt wird. Davon wurde das Objekt mit der Hintergrundfarbe bisher einmal im Inhalt behandelt.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76.png\"><img loading=\"lazy\" decoding=\"async\" width=\"985\" height=\"441\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76.png\" alt=\"\uc5d1\uc140 Object Model(\uc77c\ubd80)\" class=\"wp-image-11346\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76.png 985w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-300x134.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-768x344.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-24x11.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-36x16.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-48x21.png 48w\" sizes=\"auto, (max-width: 985px) 100vw, 985px\" \/><\/a><figcaption>Excel-Objektmodell (Teil)<\/figcaption><\/figure>\n\n\n\n<p>Sie m\u00fcssen jetzt nicht alle wei\u00dfen Hintergrundobjekte kennen. Sie k\u00f6nnen es sp\u00e4ter lernen und verwenden, wenn Sie es brauchen. F\u00fcrs Erste reicht es aus, nur darauf zu schauen, ob es so etwas gibt.<\/p>\n\n\n\n<p>Das gesamte Objekt ist auf der Microsoft Docs-Website in page1, page2 und page3 unterteilt.<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-3 wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-medium\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77.png\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"300\" data-id=\"11347\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-156x300.png\" alt=\"\uc5d1\uc140 Object Model(\uc804\uccb4) Page 1\" class=\"wp-image-11347\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-156x300.png 156w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-6x12.png 6w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-12x24.png 12w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-19x36.png 19w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-25x48.png 25w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77.png 402w\" sizes=\"auto, (max-width: 156px) 100vw, 156px\" \/><\/a><figcaption>Excel-Objektmodell (alle) Seite 1<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-medium\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78.png\"><img loading=\"lazy\" decoding=\"async\" width=\"217\" height=\"300\" data-id=\"11348\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-217x300.png\" alt=\"\uc5d1\uc140 Object Model(\uc804\uccb4) Page 2\" class=\"wp-image-11348\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-217x300.png 217w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-9x12.png 9w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-17x24.png 17w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-26x36.png 26w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-35x48.png 35w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78.png 573w\" sizes=\"auto, (max-width: 217px) 100vw, 217px\" \/><\/a><figcaption>Excel-Objektmodell (alle) Seite 2<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-medium\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png\"><img loading=\"lazy\" decoding=\"async\" width=\"260\" height=\"300\" data-id=\"11349\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-260x300.png\" alt=\"\uc5d1\uc140 Object Model(\uc804\uccb4) Page 3\" class=\"wp-image-11349\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-260x300.png 260w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-10x12.png 10w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-21x24.png 21w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-31x36.png 31w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-42x48.png 42w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png 618w\" sizes=\"auto, (max-width: 260px) 100vw, 260px\" \/><\/a><figcaption>Excel-Objektmodell (alle) Seite 3<\/figcaption><\/figure>\n<figcaption class=\"blocks-gallery-caption\">Excel-Objektmodell (alle)<\/figcaption><\/figure>\n\n\n\n<p>Die Quelle jedes obigen Bildes ist die folgende URL.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Seite 1:&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/developer\/office-xp\/aa141044(v=office.10)?redirectedfrom=MSDN\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/developer\/office-xp\/aa141044(v=office.10)?redirectedfrom=MSDN<\/a><\/li><li>Seite 2:&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/office-10\/aa189565(v=office.10)?redirectedfrom=MSDN\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/office-10\/aa189565(v=office.10)?redirectedfrom=MSDN<\/a><\/li><li>Seite 3:&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/office-10\/aa189566(v=office.10)?redirectedfrom=MSDN\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/office-10\/aa189566(v=office.10)?redirectedfrom=MSDN<\/a><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Oben haben wir uns das Excel-Objektmodell im Detail angesehen. Als N\u00e4chstes werde ich die Referenzen in Bezug auf Excel VBA erl\u00e4utern.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt;Verwandte Artikelliste &gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-preface\/\">Starten Sie den Excel-VBA-Kurs. (Vorlesungsank\u00fcndigung, feat. Warum wir Excel VBA empfehlen)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-1-overview\/\">Excel VBA-Kurs(1): \u00dcberblick \u00fcber Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-2-basic\/\">Excel VBA-Kurs (2): Excel VBA-Grundlagen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/\">Excel VBA-Kurs (3): Excel-Objektmodell<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-4-handling-object-model\/\">Excel VBA-Kurs (4): Arbeiten mit dem Excel-Objektmodell<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">Excel VBA-Kurs (5): Excel-Dateierweiterung, VBE, Schrifteinstellungen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-6-variable\/\">Excel VBA-Kurs (6): Grundlagen der Excel VBA-Sprache \u2013 Variablen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-7-syntax\/\">Excel VBA-Kurs (7): Grundlagen der Excel VBA-Sprache \u2013 Syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-8-datatype\/\">Excel VBA-Kurs (8): Grundlagen der Excel VBA-Sprache \u2013 Datentypen, Datenstrukturen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-9-how-to\/\">Excel VBA-Kurse (9): Excel VBA How-To<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-10-self-developed-tools\/\">Excel VBA-Kurs (10): Tools, die mit Excel VBA entwickelt und verwendet werden<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-toc\/\">Vollst\u00e4ndiges Inhaltsverzeichnis f\u00fcr Excel VBA-Kurse<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>In diesem Artikel schauen wir uns an, wie man mit dem Excel-Objektmodell umgeht. 2.4. Verstehen des Excel-Objektmodells mit einfachem Code 2.4.1. Schauen wir uns den grundlegendsten Code f\u00fcr den Zugriff auf grundlegende Objektzugriffsdateien, -bl\u00e4tter, -bereiche und -zellen an. Als Referenz kann die globale Objektanwendung beim Zugriff auf ein Objekt weggelassen werden. 1 unten...<\/p>","protected":false},"author":1,"featured_media":11349,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11344","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-tutorial","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc5d1\uc140 Object Model\uc744 \ub2e4\ub8e8\ub294 \ubc29\ubc95\uc744 1)\uac1d\uccb4 \uc811\uadfc \uae30\ubcf8\ud615, 2)\uac1d\uccb4 \uc811\uadfc \ub2e8\uc21c\ud615, 3)\uac1d\uccb4 \uc811\uadfc &amp; \ud65c\uc6a9 \uc608\uc81c\ub85c \ub098\ub204\uc5b4 \uc608\uc2dc\ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uace0 \uc5d1\uc140 Object Model\uc758 \uc0c1\uc138 \ub0b4\uc6a9\uc744 \uc54c\uc544\ubcf8\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\/de\/excel-vba-lecture-4-handling-object-model\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc5d1\uc140 Object Model\uc744 \ub2e4\ub8e8\ub294 \ubc29\ubc95\uc744 1)\uac1d\uccb4 \uc811\uadfc \uae30\ubcf8\ud615, 2)\uac1d\uccb4 \uc811\uadfc \ub2e8\uc21c\ud615, 3)\uac1d\uccb4 \uc811\uadfc &amp; \ud65c\uc6a9 \uc608\uc81c\ub85c \ub098\ub204\uc5b4 \uc608\uc2dc\ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uace0 \uc5d1\uc140 Object Model\uc758 \uc0c1\uc138 \ub0b4\uc6a9\uc744 \uc54c\uc544\ubcf8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-4-handling-object-model\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T03:40:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T02:40:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png\" \/>\n\t<meta property=\"og:image:width\" content=\"618\" \/>\n\t<meta property=\"og:image:height\" content=\"714\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30\",\"datePublished\":\"2022-09-11T03:40:12+00:00\",\"dateModified\":\"2022-10-11T02:40:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/\"},\"wordCount\":175,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-79.png\",\"keywords\":[\"\uc5d1\uc140VBA\"],\"articleSection\":[\"\uc5d1\uc140 VBA \uac15\uc88c\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-79.png\",\"datePublished\":\"2022-09-11T03:40:12+00:00\",\"dateModified\":\"2022-10-11T02:40:26+00:00\",\"description\":\"\uc5d1\uc140 Object Model\uc744 \ub2e4\ub8e8\ub294 \ubc29\ubc95\uc744 1)\uac1d\uccb4 \uc811\uadfc \uae30\ubcf8\ud615, 2)\uac1d\uccb4 \uc811\uadfc \ub2e8\uc21c\ud615, 3)\uac1d\uccb4 \uc811\uadfc & \ud65c\uc6a9 \uc608\uc81c\ub85c \ub098\ub204\uc5b4 \uc608\uc2dc\ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uace0 \uc5d1\uc140 Object Model\uc758 \uc0c1\uc138 \ub0b4\uc6a9\uc744 \uc54c\uc544\ubcf8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-79.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-79.png\",\"width\":618,\"height\":714,\"caption\":\"\uc5d1\uc140 Object Model(\uc804\uccb4) Page 3\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-4-handling-object-model\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30\"}]},{\"@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\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\\\/de\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VBA-Tutorial (4): Umgang mit dem Excel-Objektmodell - Produktivit\u00e4tskompetenz","description":"Wir werden uns Beispielcodes ansehen, um mehr \u00fcber die Details des Excel-Objektmodells zu erfahren, indem wir die Methode zur Handhabung des Excel-Objektmodells in 1) grundlegenden Objektzugriff, 2) einfachen Objektzugriff und 3) Beispiele f\u00fcr Objektzugriff und -verwendung unterteilen.","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\/de\/excel-vba-lecture-4-handling-object-model\/","og_locale":"de_DE","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc5d1\uc140 Object Model\uc744 \ub2e4\ub8e8\ub294 \ubc29\ubc95\uc744 1)\uac1d\uccb4 \uc811\uadfc \uae30\ubcf8\ud615, 2)\uac1d\uccb4 \uc811\uadfc \ub2e8\uc21c\ud615, 3)\uac1d\uccb4 \uc811\uadfc & \ud65c\uc6a9 \uc608\uc81c\ub85c \ub098\ub204\uc5b4 \uc608\uc2dc\ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uace0 \uc5d1\uc140 Object Model\uc758 \uc0c1\uc138 \ub0b4\uc6a9\uc744 \uc54c\uc544\ubcf8\ub2e4.","og_url":"https:\/\/prodskill.com\/de\/excel-vba-lecture-4-handling-object-model\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T03:40:12+00:00","article_modified_time":"2022-10-11T02:40:26+00:00","og_image":[{"width":618,"height":714,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"Zerom","Gesch\u00e4tzte Lesezeit":"5\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30","datePublished":"2022-09-11T03:40:12+00:00","dateModified":"2022-10-11T02:40:26+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/"},"wordCount":175,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png","keywords":["\uc5d1\uc140VBA"],"articleSection":["\uc5d1\uc140 VBA \uac15\uc88c"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/","name":"Excel VBA-Tutorial (4): Umgang mit dem Excel-Objektmodell - Produktivit\u00e4tskompetenz","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png","datePublished":"2022-09-11T03:40:12+00:00","dateModified":"2022-10-11T02:40:26+00:00","description":"Wir werden uns Beispielcodes ansehen, um mehr \u00fcber die Details des Excel-Objektmodells zu erfahren, indem wir die Methode zur Handhabung des Excel-Objektmodells in 1) grundlegenden Objektzugriff, 2) einfachen Objektzugriff und 3) Beispiele f\u00fcr Objektzugriff und -verwendung unterteilen.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png","width":618,"height":714,"caption":"\uc5d1\uc140 Object Model(\uc804\uccb4) Page 3"},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Produktivit\u00e4tsf\u00e4higkeiten","description":"Meta-Denken, Meta-Arbeiten","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":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Nullm","image":{"@type":"ImageObject","inLanguage":"de","@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\/de\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/comments?post=11344"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11344\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media\/11349"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media?parent=11344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/categories?post=11344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/tags?post=11344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}