{"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\/es\/excel-vba-lecture-4-handling-object-model\/","title":{"rendered":"Curso de Excel VBA (4): Trabajar con el modelo de objetos de Excel"},"content":{"rendered":"<p>En este art\u00edculo, veremos c\u00f3mo manejar el modelo de objetos de Excel.<\/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;Tabla de contenidos&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=\"Pesta\u00f1a de contenido alternativo\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Palanca<\/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\/es\/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. Comprender el modelo de objetos de Excel con c\u00f3digo simple<\/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\/es\/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. primitiva de acceso a objetos<\/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\/es\/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. acceso a objetos sencillo<\/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\/es\/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. Ejemplos de acceso y uso de objetos<\/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\/es\/excel-vba-lecture-4-handling-object-model\/#25_%EC%97%91%EC%85%80_Object_Model_%EC%83%81%EC%84%B8\" >2.5. Detalles del modelo de objetos de Excel<\/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. Comprender el modelo de objetos de Excel con c\u00f3digo simple<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. primitiva de acceso a objetos<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Veamos el c\u00f3digo m\u00e1s b\u00e1sico que accede a archivos, hojas, rangos y celdas. Como referencia, el objeto global Aplicaci\u00f3n se puede omitir al acceder al objeto. En la segunda l\u00ednea de cada ejemplo del 1 al 6 a continuaci\u00f3n, se expresa el c\u00f3digo que omite la aplicaci\u00f3n.<\/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>Echemos un vistazo m\u00e1s de cerca a cada uno.<\/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 Esta es una sintaxis que indica el archivo cuyo nombre es \u201ct1.xlsx\u201d entre los archivos abiertos actualmente en Excel. Workbooks mantiene una colecci\u00f3n de archivos abiertos. Al seleccionar uno de varios archivos, acceda al &#039;nombre de archivo&#039; de la colecci\u00f3n Workbooks como par\u00e1metro. (Como referencia, adem\u00e1s del nombre del archivo, tambi\u00e9n se puede usar como par\u00e1metro el orden en que se abri\u00f3 el archivo, como &quot;Libros de trabajo (1)&quot;).<\/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 Esta es una sintaxis que indica la hoja &quot;Hoja1&quot; del archivo &quot;t1.xlsx&quot; especificado anteriormente. Las hojas de trabajo administran una colecci\u00f3n de hojas en un archivo. Al seleccionar una de varias hojas, acceda al &#039;nombre de la hoja&#039; de la colecci\u00f3n Hojas de trabajo como par\u00e1metro. (Al igual que los libros de trabajo, tambi\u00e9n puede usar el orden de las hojas como par\u00e1metro, como &quot;Hojas de trabajo (1)&quot;.)<\/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 Esta es una frase que indica la celda &quot;A1&quot; de la hoja &quot;Hoja1&quot; especificada anteriormente.<\/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 Este c\u00f3digo ingresa un valor de cadena a la celda a la que se accedi\u00f3 anteriormente. Puede ingresar cualquier tipo de valor, incluidas cadenas y n\u00fameros.<\/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 Este c\u00f3digo establece el formato de celda utilizando el objeto Rango. Todos los formatos de celda, como el nombre de fuente, el color, el tama\u00f1o, el color de fondo, el tipo de borde de celda y el color del borde, se pueden configurar con el c\u00f3digo VBA.<\/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 Un objeto Rango puede apuntar a varias celdas contiguas. El rango (&quot;A2:D4&quot;) representa &#039;2 filas, 1 columna&#039; a &#039;4 filas, 4 columnas&#039;.<\/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>Rango (&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. acceso a objetos sencillo<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Al acceder al archivo o la hoja actual, simplemente puede usarlo de la siguiente manera. Este c\u00f3digo es simple y muy legible, pero se debe tener cuidado cuando se cambia el archivo o la hoja actual durante la ejecuci\u00f3n.<\/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. Ejemplos de acceso y uso de objetos<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Veamos algunos ejemplos m\u00e1s de acceso a objetos.<\/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. Detalles del modelo de objetos de Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>La estructura jer\u00e1rquica del modelo de objetos de Excel de uso frecuente es la siguiente. Los objetos que se muestran en esta figura son una parte, no el todo, proporcionados a Excel VBA. De estos, el objeto con el color de fondo se ha tratado una vez en los contenidos hasta ahora.&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>Modelo de objetos de Excel (parte)<\/figcaption><\/figure>\n\n\n\n<p>No necesita saber todos los objetos de fondo blanco ahora. Puede aprenderlo y usarlo m\u00e1s tarde cuando lo necesite. Por ahora, solo mirarlo para ver si existe tal cosa es suficiente.<\/p>\n\n\n\n<p>Todo el objeto se divide en p\u00e1gina1, p\u00e1gina2 y p\u00e1gina3 en el sitio de Microsoft Docs.<\/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>Modelo de objetos de Excel (Todos) P\u00e1gina 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>Modelo de objetos de Excel (Todos) P\u00e1gina 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>Modelo de objetos de Excel (Todos) P\u00e1gina 3<\/figcaption><\/figure>\n<figcaption class=\"blocks-gallery-caption\">Modelo de objetos de Excel(Todos)<\/figcaption><\/figure>\n\n\n\n<p>La fuente de cada imagen de arriba es la siguiente URL.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>P\u00e1gina 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>P\u00e1gina 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>P\u00e1gina 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>Arriba, vimos el modelo de objetos de Excel en detalle. A continuaci\u00f3n, explicar\u00e9 las referencias relacionadas con Excel VBA.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt; Lista de art\u00edculos relacionados &gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-preface\/\">Inicie el curso de Excel VBA. (Aviso de conferencia, haza\u00f1a. Por qu\u00e9 recomendamos Excel VBA)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-1-overview\/\">Curso Excel VBA(1): Descripci\u00f3n general de Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-2-basic\/\">Curso de Excel VBA (2): Conceptos b\u00e1sicos de Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-3-object-model\/\">Curso de Excel VBA (3): Modelo de objetos de Excel<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-4-handling-object-model\/\">Curso de Excel VBA (4): Trabajar con el modelo de objetos de Excel<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">Curso de Excel VBA (5): extensi\u00f3n de archivo de Excel, VBE, configuraci\u00f3n de fuente<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-6-variable\/\">Curso Excel VBA (6): Conceptos b\u00e1sicos del lenguaje Excel VBA - Variables<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-7-syntax\/\">Curso Excel VBA (7): Conceptos b\u00e1sicos del lenguaje Excel VBA - Sintaxis<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-8-datatype\/\">Curso Excel VBA (8): Conceptos b\u00e1sicos del lenguaje Excel VBA: tipos de datos, estructuras de datos<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/\">Cursos de Excel VBA (9): Procedimientos de Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-10-self-developed-tools\/\">Curso Excel VBA (10): Herramientas desarrolladas y utilizadas con Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-toc\/\">Tabla de contenido completa para cursos de Excel VBA<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>En este art\u00edculo, veremos c\u00f3mo manejar el modelo de objetos de Excel. 2.4. Comprender el modelo de objetos de Excel con c\u00f3digo simple 2.4.1. Acceso b\u00e1sico a objetos Veamos el c\u00f3digo m\u00e1s b\u00e1sico que accede a archivos, hojas, rangos y celdas. Como referencia, el objeto global Aplicaci\u00f3n se puede omitir al acceder al objeto. 1 abajo...<\/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.2 - 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\/es\/excel-vba-lecture-4-handling-object-model\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\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\/es\/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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\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\":\"es\",\"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\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tutorial de VBA en Excel (4): Manejo del modelo de objetos de Excel - Habilidad de productividad","description":"Veremos c\u00f3digos de ejemplo para conocer los detalles del modelo de objetos de Excel dividiendo el m\u00e9todo de manejo del modelo de objetos de Excel en 1) acceso b\u00e1sico a objetos, 2) acceso simple a objetos y 3) ejemplos de acceso y utilizaci\u00f3n de objetos.","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\/es\/excel-vba-lecture-4-handling-object-model\/","og_locale":"es_ES","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\/es\/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":{"Escrito por":"Zerom","Tiempo de lectura":"5 minutos"},"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":"es","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":"Tutorial de VBA en Excel (4): Manejo del modelo de objetos de Excel - Habilidad de productividad","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":"Veremos c\u00f3digos de ejemplo para conocer los detalles del modelo de objetos de Excel dividiendo el m\u00e9todo de manejo del modelo de objetos de Excel en 1) acceso b\u00e1sico a objetos, 2) acceso simple a objetos y 3) ejemplos de acceso y utilizaci\u00f3n de objetos.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/"]}]},{"@type":"ImageObject","inLanguage":"es","@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":"Habilidades de productividad","description":"Meta Pensamiento, Meta Trabajo","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":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Cerom","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/comments?post=11344"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11344\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media\/11349"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media?parent=11344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/categories?post=11344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/tags?post=11344"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}