{"id":735,"date":"2023-09-02T06:07:44","date_gmt":"2023-09-02T06:07:44","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/"},"modified":"2023-12-25T10:27:20","modified_gmt":"2023-12-25T10:27:20","slug":"el-objeto-no-admite-esta-propiedad-o-metodo-error-438","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/","title":{"rendered":"\u00bfc\u00f3mo solucionar el error 438 de vba en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3237284819\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>El error 438 de VBA ocurre cuando intenta utilizar una propiedad o m\u00e9todo que no admite este objeto. Como sabe, todos los objetos tienen propiedades y m\u00e9todos que puede usar, pero puede haber una situaci\u00f3n en la que se use una propiedad o m\u00e9todo que no se aplica a un objeto en particular.<\/p>\n<p> <strong>Mensaje de error:<\/strong><\/p>\n<ul>\n<li> El objeto VBA no admite esta propiedad o error de m\u00e9todo (Error 438)<\/li>\n<\/ul>\n<p> Pongamos un ejemplo para entender esto: junto al objeto hoja de c\u00e1lculo aparece un m\u00e9todo para seleccionar la hoja de c\u00e1lculo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57067\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png\" sizes=\"auto, \" srcset=\"\" alt=\"propiedad vba_object_does_not_support_this_\" width=\"368\" height=\"266\"><\/figure>\n<\/div>\n<p> Ahora, como sabe, puede activar un libro de trabajo, pero no existe ning\u00fan m\u00e9todo que pueda utilizar para seleccionar un libro de trabajo porque no puede seleccionar un libro de trabajo, solo puede activarlo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57068\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2_activate_a_workbook.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"555\" height=\"421\"><\/figure>\n<\/div>\n<p> Entonces, cuando intenta utilizar este m\u00e9todo con un objeto de libro, obtiene el error de ejecuci\u00f3n 438. Incluso puede ver que este m\u00e9todo no est\u00e1 en la lista de propiedades y m\u00e9todos del objeto de libro. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57069\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3_runtime_error_438.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"562\" height=\"374\"><\/figure>\n<\/div>\n<p> Ahora puede comprender que esto puede ser un error por parte de la persona que escribe el c\u00f3digo y puede cometerse incluso si domina VBA.<\/p>\n<p class=\"qt-tip\"> <strong>Nota:<\/strong> Cuando escribi\u00f3 c\u00f3digo en la \u00faltima versi\u00f3n de Microsoft Excel y ahora intenta ejecutarlo en una versi\u00f3n anterior, es posible que esa versi\u00f3n no tenga un m\u00e9todo o propiedad para el objeto que utiliza. .<\/p>\n<h2 class=\"wp-block-heading\"> C\u00f3mo arreglar un objeto que no admite esta propiedad o m\u00e9todo<\/h2>\n<p> La mejor manera de manejar este error 438 (el objeto no admite esta propiedad o m\u00e9todo) es conocer las propiedades y m\u00e9todos admitidos por el objeto que est\u00e1 utilizando.<\/p>\n<p> Cuando define un objeto, puede ver la lista de todas las propiedades y m\u00e9todos cuando escribe un punto (.). <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57070\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4_fix_object_doesnot_support_this_property.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"603\" height=\"349\"><\/figure>\n<\/div>\n<p> Esta lista puede ayudarle a decidir si el m\u00e9todo que desea utilizar est\u00e1 presente o no. Y si no es as\u00ed, necesita encontrar otra forma de escribir c\u00f3digo para la tarea que desea realizar. Alternativamente, tambi\u00e9n puede abrir el Explorador de objetos (F2) para ver las propiedades y m\u00e9todos que tiene con un objeto.<\/p>\n<div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/manejo-de-errores\/\">Manejo de errores de VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/error-de-automatizacion-440\/\">Error de automatizaci\u00f3n de VBA (Error 440)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/error-400\/\">Error 400 de VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/llamada-a-procedimiento-no-valida-o-error-de-argumento-5\/\">Llamada a procedimiento VBA no v\u00e1lida o error de argumento (Error 5)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/error-de-objeto-requerido-424\/\">Error de objeto VBA requerido (Error 424)<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-50067b57\">\n<div class=\"gb-container gb-container-50067b57\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>El error 438 de VBA ocurre cuando intenta utilizar una propiedad o m\u00e9todo que no admite este objeto. Como sabe, todos los objetos tienen propiedades y m\u00e9todos que puede usar, pero puede haber una situaci\u00f3n en la que se use una propiedad o m\u00e9todo que no se aplica a un objeto en particular. Mensaje de [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-735","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo solucionar el error 438 de vba en excel?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo solucionar el error 438 de vba en excel?\" \/>\n<meta property=\"og:description\" content=\"El error 438 de VBA ocurre cuando intenta utilizar una propiedad o m\u00e9todo que no admite este objeto. Como sabe, todos los objetos tienen propiedades y m\u00e9todos que puede usar, pero puede haber una situaci\u00f3n en la que se use una propiedad o m\u00e9todo que no se aplica a un objeto en particular. Mensaje de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/\",\"name\":\"\u00bfc\u00f3mo solucionar el error 438 de vba en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png\",\"datePublished\":\"2023-09-02T06:07:44+00:00\",\"dateModified\":\"2023-12-25T10:27:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo solucionar el error 438 de vba en excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo solucionar el error 438 de vba en excel?","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:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo solucionar el error 438 de vba en excel?","og_description":"El error 438 de VBA ocurre cuando intenta utilizar una propiedad o m\u00e9todo que no admite este objeto. Como sabe, todos los objetos tienen propiedades y m\u00e9todos que puede usar, pero puede haber una situaci\u00f3n en la que se use una propiedad o m\u00e9todo que no se aplica a un objeto en particular. Mensaje de [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:20+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/","url":"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/","name":"\u00bfc\u00f3mo solucionar el error 438 de vba en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png","datePublished":"2023-09-02T06:07:44+00:00","dateModified":"2023-12-25T10:27:20+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1_vba_object_does_not_support_this_-propriete.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/el-objeto-no-admite-esta-propiedad-o-metodo-error-438\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo solucionar el error 438 de vba en excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=735"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/735\/revisions"}],"predecessor-version":[{"id":1194,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/735\/revisions\/1194"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}