{"id":1933,"date":"2010-12-16T10:03:00","date_gmt":"2010-12-16T10:03:00","guid":{"rendered":""},"modified":"2022-08-08T09:37:20","modified_gmt":"2022-08-08T09:37:20","slug":"gestinmo-y-otras-hojas-de-excel","status":"publish","type":"post","link":"https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/","title":{"rendered":"Gestinmo y otras hojas de Excel simultaneamente"},"content":{"rendered":"<p><!--[if gte mso 9]><xml>  <w:worddocument>   <w:view>Normal<\/w:View>   <w:zoom>0<\/w:Zoom>   <w:hyphenationzone>21<\/w:HyphenationZone>   <w:punctuationkerning\/>   <w:validateagainstschemas\/>   <w:saveifxmlinvalid>false<\/w:SaveIfXMLInvalid>   <w:ignoremixedcontent>false<\/w:IgnoreMixedContent>   <w:alwaysshowplaceholdertext>false<\/w:AlwaysShowPlaceholderText>   <w:compatibility>    <w:breakwrappedtables\/>    <w:snaptogridincell\/>    <w:wraptextwithpunct\/>    <w:useasianbreakrules\/>    <w:dontgrowautofit\/>   <\/w:Compatibility>   <w:browserlevel>MicrosoftInternetExplorer4<\/w:BrowserLevel>  <\/w:WordDocument> <\/xml><![endif]--><!--[if gte mso 9]><xml>  <w:latentstyles deflockedstate=\"false\" latentstylecount=\"156\">  <\/w:LatentStyles> <\/xml><![endif]--><!--[if !mso]><object classid=\"clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D\" id=\"ieooui\"><\/object> \n\n<style> st1:*{behavior:url(#ieooui) } <\/style>\n\n <![endif]--><!--[if gte mso 10]> \n\n<style>  \/* Style Definitions *\/  table.MsoNormalTable  {mso-style-name:\"Tabla normal\";  mso-tstyle-rowband-size:0;  mso-tstyle-colband-size:0;  mso-style-noshow:yes;  mso-style-parent:\"\";  mso-padding-alt:0cm 5.4pt 0cm 5.4pt;  mso-para-margin:0cm;  mso-para-margin-bottom:.0001pt;  mso-pagination:widow-orphan;  font-size:10.0pt;  font-family:\"Times New Roman\";  mso-ansi-language:#0400;  mso-fareast-language:#0400;  mso-bidi-language:#0400;} <\/style>\n\n <![endif]-->    <\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 11pt; font-family: Arial;\"> <\/span><b style=\"\"><span style=\"font-size: 11pt; font-family: Arial;\">Gestinmo<\/span><\/b><span style=\"font-size: 11pt; font-family: Arial;\"> y nuestros otros programas inform\u00e1ticos de Analisis de Viabilidad consisten, como es bien sabido por los usuarios, en <b style=\"\">libros de Excel<\/b>, con sus hojas, formulas y con programaci\u00f3n especifica (macros) para el mejor manejo del programa por usuarios no expertos en Excel<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 11pt; font-family: Arial;\">Especificamente, <b style=\"\">cuando Gestinmo se abre<\/b>, abre una \u201cinstancia\u201d (copia abierta del programa generico) de <b style=\"\">Excel y \u201ctoma el control\u201d del mismo<\/b>, haciendo aparecer su propio menu y deshabilitando o sustituyendo algunas posibilidades de Excel.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 11pt; font-family: Arial;\">Por ejemplo, la opcion \u201cSalir\u201d de Gestinmo es ligeramente diferente de la de Excel puesto que no solo cierra el libro \u201cGestinmo.xls\u201d sino tambien el propio Excel incondicionalmente y sin preguntar mas<\/span><\/p>\n<p style=\"text-align: justify;\"><b style=\"\"><span style=\"font-size: 11pt; font-family: Arial;\">Hay veces en que el usuario desea tener abierto s\u00edmult\u00e1neamente<\/span><\/b><span style=\"font-size: 11pt; font-family: Arial;\">, no solamente Gestinmo, sino <b style=\"\">otra hoja de Excel,<\/b> por diversas razones: copiar o visualizar algun dato, ver 2 estudios simultaneamente, comprobar que una exportacion se ha realizado correctamente, etc<\/span><\/p>\n<p style=\"text-align: justify;\"><b style=\"\"><span style=\"font-size: 11pt; font-family: Arial;\">Lo habitual es pinchar 2 veces<\/span><\/b><span style=\"font-size: 11pt; font-family: Arial;\"> sobre la hoja correspondiente (pepe.xls, por ejemplo). Entonces, pepe se abre sobre la \u201cinstancia\u201d de Excel que ya esta abierta y ya esta. Esto es normal y es lo que se hace siempre. Pero cuando estamos usando Gestinmo, la \u201cinstancia\u201d de Excel previamente abierta esta \u201cdominada\u201d por Gestinmo y entonces podemos tener problemas a la hora de guardar esa segunda hoja, a la hora de manejar los menus de Excel, etc. <b style=\"\">NO DEBEMOS HACERLO ASI CUANDO USEMOS GESTINMO<\/b><\/span><\/p>\n<p style=\"text-align: justify;\"><b style=\"\"><span style=\"font-size: 11pt; font-family: Arial;\">Cuando estamos usando Gestinmo y queremos abrir otra hoja de calculo<\/span><\/b><span style=\"font-size: 11pt; font-family: Arial;\"> (pepe.xls), para evitar problemas hay que <b style=\"\">abrir UNA SEGUNDA INSTANCIA DE EXCEL y, sobre \u00e9sta, ABRIR LA  NUEVA HOJA<\/b> (pepe). Asi evitamos que Gestimno y pepe se \u201cmezclen\u201d. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 11pt; font-family: Arial;\">El <b style=\"\">procedimiento<\/b> es el siguiente:<\/span><\/p>\n<ul style=\"margin-top: 0cm;\" type=\"disc\">\n<li style=\"text-align: justify;\"><span style=\"font-size: 11pt; font-family: Arial;\">Tenemos      <b style=\"\">abierto un Gestinmo<\/b><\/span><\/li>\n<li style=\"text-align: justify;\"><b style=\"\"><span style=\"font-size: 11pt; font-family: Arial;\">Abrimos otro programa Excel<\/span><\/b><span style=\"font-size: 11pt; font-family: Arial;\">, pinchando 2 veces sobre el      icono de Excel, el cual se abrir\u00e1 con una hoja en blanco<\/span><\/li>\n<li style=\"text-align: justify;\"><b style=\"\"><span style=\"font-size: 11pt; font-family: Arial;\">Desde este<\/span><\/b><span style=\"font-size: 11pt; font-family: Arial;\"> segundo Excel, buscamos y <b style=\"\">abrimos la hoja<\/b> que queramos<\/span><span style=\"font-size: 11pt; font-family: Arial;\"><span style=\"\">                                                                                       <\/span><\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><b style=\"\"><span style=\"font-size: 11pt; font-family: Arial;\">Asi tendremos 2 \u201cinstancias\u201d (copias) de Excel independientes<\/span><\/b><span style=\"font-size: 11pt; font-family: Arial;\">, cada una con una hoja diferente y que no chocan una con otra ni se influyen<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 11pt; font-family: Arial;\">Este procedimiento nos permite tener abiertas varias hojas con total seguridad y nos abre muchas posibilidades de manejo: Tener 2 Gestinmos abiertos a la vez, o 1 gestinmo y 1 InmoSuelo, ver o copiar datos o resultados procedentes de otros origenes, etc.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 11pt; font-family: Arial;\">Aprovechamos la fecha para desearles a todos <span style=\"font-weight: bold;\">FELICES PASCUAS Y PROSPERO A\u00d1O NUEVO<\/span>. Y, para que las puedan celebrar debidamente, les vamos a dejar en Paz durante estos dias, asi que <span style=\"font-weight: bold;\">reanudaremos la  publicacion a partir de la primera semana de 2011. <\/span>Muchas felicidades<br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gestinmo y nuestros otros programas inform\u00e1ticos de Analisis de Viabilidad consisten, como es bien sabido por los usuarios, en libros de Excel, con sus hojas, formulas y con programaci\u00f3n especifica\u2026 <a class=\"continue-reading-link\" href=\"https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/\">Continue leyendo<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[15,33],"class_list":["post-1933","post","type-post","status-publish","format-standard","hentry","category-sin-categoria","tag-gestinmo","tag-opinion"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Gestinmo y otras hojas de Excel simultaneamente - Gestinmo<\/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:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Gestinmo y otras hojas de Excel simultaneamente - Gestinmo\" \/>\n<meta property=\"og:description\" content=\"Gestinmo y nuestros otros programas inform\u00e1ticos de Analisis de Viabilidad consisten, como es bien sabido por los usuarios, en libros de Excel, con sus hojas, formulas y con programaci\u00f3n especifica\u2026 Continue leyendo\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Gestinmo\" \/>\n<meta property=\"article:published_time\" content=\"2010-12-16T10:03:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-08T09:37:20+00:00\" \/>\n<meta name=\"author\" content=\"Juan Fernandez Caparros\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Juan Fernandez Caparros\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/gestinmo-y-otras-hojas-de-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/gestinmo-y-otras-hojas-de-excel\\\/\"},\"author\":{\"name\":\"Juan Fernandez Caparros\",\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/#\\\/schema\\\/person\\\/ef6008d6bbfeae510b73653264512798\"},\"headline\":\"Gestinmo y otras hojas de Excel simultaneamente\",\"datePublished\":\"2010-12-16T10:03:00+00:00\",\"dateModified\":\"2022-08-08T09:37:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/gestinmo-y-otras-hojas-de-excel\\\/\"},\"wordCount\":429,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/#organization\"},\"keywords\":[\"Gestinmo\",\"Opinion\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prayde.com\\\/empresa\\\/gestinmo-y-otras-hojas-de-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/gestinmo-y-otras-hojas-de-excel\\\/\",\"url\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/gestinmo-y-otras-hojas-de-excel\\\/\",\"name\":\"Gestinmo y otras hojas de Excel simultaneamente - Gestinmo\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/#website\"},\"datePublished\":\"2010-12-16T10:03:00+00:00\",\"dateModified\":\"2022-08-08T09:37:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/gestinmo-y-otras-hojas-de-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prayde.com\\\/empresa\\\/gestinmo-y-otras-hojas-de-excel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/gestinmo-y-otras-hojas-de-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Gestinmo y otras hojas de Excel simultaneamente\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/#website\",\"url\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/\",\"name\":\"Gestinmo\",\"description\":\"Analizar la Rentabilidad y Riesgos de una Promocion Inmobiliaria\",\"publisher\":{\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/#organization\",\"name\":\"Gestinmo\",\"url\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/cropped-cropped-Prayde-Pe.jpg\",\"contentUrl\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/cropped-cropped-Prayde-Pe.jpg\",\"width\":512,\"height\":512,\"caption\":\"Gestinmo\"},\"image\":{\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/#\\\/schema\\\/person\\\/ef6008d6bbfeae510b73653264512798\",\"name\":\"Juan Fernandez Caparros\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"caption\":\"Juan Fernandez Caparros\"},\"url\":\"https:\\\/\\\/prayde.com\\\/empresa\\\/author\\\/06357885663078594681\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Gestinmo y otras hojas de Excel simultaneamente - Gestinmo","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:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Gestinmo y otras hojas de Excel simultaneamente - Gestinmo","og_description":"Gestinmo y nuestros otros programas inform\u00e1ticos de Analisis de Viabilidad consisten, como es bien sabido por los usuarios, en libros de Excel, con sus hojas, formulas y con programaci\u00f3n especifica\u2026 Continue leyendo","og_url":"https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/","og_site_name":"Gestinmo","article_published_time":"2010-12-16T10:03:00+00:00","article_modified_time":"2022-08-08T09:37:20+00:00","author":"Juan Fernandez Caparros","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Juan Fernandez Caparros","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/#article","isPartOf":{"@id":"https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/"},"author":{"name":"Juan Fernandez Caparros","@id":"https:\/\/prayde.com\/empresa\/#\/schema\/person\/ef6008d6bbfeae510b73653264512798"},"headline":"Gestinmo y otras hojas de Excel simultaneamente","datePublished":"2010-12-16T10:03:00+00:00","dateModified":"2022-08-08T09:37:20+00:00","mainEntityOfPage":{"@id":"https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/"},"wordCount":429,"commentCount":0,"publisher":{"@id":"https:\/\/prayde.com\/empresa\/#organization"},"keywords":["Gestinmo","Opinion"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/","url":"https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/","name":"Gestinmo y otras hojas de Excel simultaneamente - Gestinmo","isPartOf":{"@id":"https:\/\/prayde.com\/empresa\/#website"},"datePublished":"2010-12-16T10:03:00+00:00","dateModified":"2022-08-08T09:37:20+00:00","breadcrumb":{"@id":"https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/prayde.com\/empresa\/gestinmo-y-otras-hojas-de-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/prayde.com\/empresa\/"},{"@type":"ListItem","position":2,"name":"Gestinmo y otras hojas de Excel simultaneamente"}]},{"@type":"WebSite","@id":"https:\/\/prayde.com\/empresa\/#website","url":"https:\/\/prayde.com\/empresa\/","name":"Gestinmo","description":"Analizar la Rentabilidad y Riesgos de una Promocion Inmobiliaria","publisher":{"@id":"https:\/\/prayde.com\/empresa\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prayde.com\/empresa\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/prayde.com\/empresa\/#organization","name":"Gestinmo","url":"https:\/\/prayde.com\/empresa\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/prayde.com\/empresa\/#\/schema\/logo\/image\/","url":"https:\/\/prayde.com\/empresa\/wp-content\/uploads\/2018\/12\/cropped-cropped-Prayde-Pe.jpg","contentUrl":"https:\/\/prayde.com\/empresa\/wp-content\/uploads\/2018\/12\/cropped-cropped-Prayde-Pe.jpg","width":512,"height":512,"caption":"Gestinmo"},"image":{"@id":"https:\/\/prayde.com\/empresa\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/prayde.com\/empresa\/#\/schema\/person\/ef6008d6bbfeae510b73653264512798","name":"Juan Fernandez Caparros","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Juan Fernandez Caparros"},"url":"https:\/\/prayde.com\/empresa\/author\/06357885663078594681\/"}]}},"_links":{"self":[{"href":"https:\/\/prayde.com\/empresa\/wp-json\/wp\/v2\/posts\/1933","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prayde.com\/empresa\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prayde.com\/empresa\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prayde.com\/empresa\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/prayde.com\/empresa\/wp-json\/wp\/v2\/comments?post=1933"}],"version-history":[{"count":0,"href":"https:\/\/prayde.com\/empresa\/wp-json\/wp\/v2\/posts\/1933\/revisions"}],"wp:attachment":[{"href":"https:\/\/prayde.com\/empresa\/wp-json\/wp\/v2\/media?parent=1933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prayde.com\/empresa\/wp-json\/wp\/v2\/categories?post=1933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prayde.com\/empresa\/wp-json\/wp\/v2\/tags?post=1933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}