Bienvenidos a nuestro blog

Aquí encontrarás actualizaciones sobre Microsoft Excel, Microsoft Access,, documentaré los tips que hemos descubierto durante nuestros desarrollos.

Access

Excel

VBA

Importe de Excel a Access

Importar archivo de Excel a Acces con VBA

Seguro que mucho de nosotros ha tenido que importar un Archivo de Excel con VBA

No hay comentarios

Separar Apellidos en Excel

Separar Nombres y Apellidos con Fórmulas en Excel

Es una operación que se utiliza mucho en algunas empresas y los usuarios de Excel

No hay comentarios

Excel y Acces conectados a MySQL VBA

Conextar Excel y Access con MySQL

Cuando desarrollamos en Excel o Microsoft Access requerimos usar bases de datos remotas y entre

2 comentarios

Exportar Consulta o Tabla Access a Excel con VBA

Exportar Consulta o Tabla Access a Excel VBA

Exportar Consulta o Tabla Access a Excel VBA, nos permitirá analizar mejor los datos. Exportar

No hay comentarios

Trabajar con hojas de Excel en VBA

Trabajar con Hojas Excel en VBA

Trabajar con hojas Excel en VBA para Excel es de uso frecuente en nuestro trabajo

No hay comentarios

html{font-size:93.75%;}a,.page-title{color:#62aeec;}a:hover,a:focus{color:#3a3a3a;}body,button,input,select,textarea,.ast-button,.ast-custom-button{font-family:"Exo 2",sans-serif;font-weight:400;font-size:15px;font-size:1rem;}blockquote{color:#000;}h1,.entry-content h1,.entry-content h1 a,h2,.entry-content h2,.entry-content h2 a,h3,.entry-content h3,.entry-content h3 a,h4,.entry-content h4,.entry-content h4 a,h5,.entry-content h5,.entry-content h5 a,h6,.entry-content h6,.entry-content h6 a,.site-title,.site-title a{font-family:"Exo 2",sans-serif;font-weight:400;}.site-title{font-size:35px;font-size:2.3333333333333rem;display:none;}header .custom-logo-link img{max-width:200px;}.astra-logo-svg{width:200px;}.ast-archive-description .ast-archive-title{font-size:40px;font-size:2.6666666666667rem;}.site-header .site-description{font-size:15px;font-size:1rem;display:none;}.entry-title{font-size:30px;font-size:2rem;}h1,.entry-content h1,.entry-content h1 a{font-size:48px;font-size:3.2rem;font-family:"Exo 2",sans-serif;}h2,.entry-content h2,.entry-content h2 a{font-size:35px;font-size:2.3333333333333rem;font-weight:600;font-family:"Exo 2",sans-serif;line-height:1.1;}h3,.entry-content h3,.entry-content h3 a{font-size:30px;font-size:2rem;font-family:"Exo 2",sans-serif;}h4,.entry-content h4,.entry-content h4 a{font-size:20px;font-size:1.3333333333333rem;}h5,.entry-content h5,.entry-content h5 a{font-size:18px;font-size:1.2rem;}h6,.entry-content h6,.entry-content h6 a{font-size:15px;font-size:1rem;}.ast-single-post .entry-title,.page-title{font-size:30px;font-size:2rem;}::selection{background-color:#62aeec;color:#000;}body,h1,.entry-title a,.entry-content h1,.entry-content h1 a,h2,.entry-content h2,.entry-content h2 a,h3,.entry-content h3,.entry-content h3 a,h4,.entry-content h4,.entry-content h4 a,h5,.entry-content h5,.entry-content h5 a,h6,.entry-content h6,.entry-content h6 a{color:#3a3a3a;}.tagcloud a:hover,.tagcloud a:focus,.tagcloud a.current-item{color:#000;border-color:#62aeec;background-color:#62aeec;}input:focus,input[type="text"]:focus,input[type="email"]:focus,input[type="url"]:focus,input[type="password"]:focus,input[type="reset"]:focus,input[type="search"]:focus,textarea:focus{border-color:#62aeec;}input[type="radio"]:checked,input[type=reset],input[type="checkbox"]:checked,input[type="checkbox"]:hover:checked,input[type="checkbox"]:focus:checked,input[type=range]::-webkit-slider-thumb{border-color:#62aeec;background-color:#62aeec;box-shadow:none;}.site-footer a:hover + .post-count,.site-footer a:focus + .post-count{background:#62aeec;border-color:#62aeec;}.single .nav-links .nav-previous,.single .nav-links .nav-next{color:#62aeec;}.entry-meta,.entry-meta *{line-height:1.45;color:#62aeec;}.entry-meta a:hover,.entry-meta a:hover *,.entry-meta a:focus,.entry-meta a:focus *,.page-links > .page-link,.page-links .page-link:hover,.post-navigation a:hover{color:#3a3a3a;}.widget-title{font-size:21px;font-size:1.4rem;color:#3a3a3a;}#cat option,.secondary .calendar_wrap thead a,.secondary .calendar_wrap thead a:visited{color:#62aeec;}.secondary .calendar_wrap #today,.ast-progress-val span{background:#62aeec;}.secondary a:hover + .post-count,.secondary a:focus + .post-count{background:#62aeec;border-color:#62aeec;}.calendar_wrap #today > a{color:#000;}.page-links .page-link,.single .post-navigation a{color:#62aeec;}.main-header-menu .menu-link,.ast-header-custom-item a{color:#3a3a3a;}.main-header-menu .menu-item:hover > .menu-link,.main-header-menu .menu-item:hover > .ast-menu-toggle,.main-header-menu .ast-masthead-custom-menu-items a:hover,.main-header-menu .menu-item.focus > .menu-link,.main-header-menu .menu-item.focus > .ast-menu-toggle,.main-header-menu .current-menu-item > .menu-link,.main-header-menu .current-menu-ancestor > .menu-link,.main-header-menu .current-menu-item > .ast-menu-toggle,.main-header-menu .current-menu-ancestor > .ast-menu-toggle{color:#62aeec;}.header-main-layout-3 .ast-main-header-bar-alignment{margin-right:auto;}.header-main-layout-2 .site-header-section-left .ast-site-identity{text-align:left;}.site-logo-img img{transition:all .2s linear;}.ast-header-break-point .ast-mobile-menu-buttons-minimal.menu-toggle{background:transparent;color:#1e73be;}.ast-header-break-point .ast-mobile-menu-buttons-outline.menu-toggle{background:transparent;border:1px solid #1e73be;color:#1e73be;}.ast-header-break-point .ast-mobile-menu-buttons-fill.menu-toggle{background:#1e73be;color:#fff;}.ast-page-builder-template .hentry{margin:0;}.ast-page-builder-template .site-content > .ast-container{max-width:100%;padding:0;}.ast-page-builder-template .site-content #primary{padding:0;margin:0;}.ast-page-builder-template .no-results{text-align:center;margin:4em auto;}.ast-page-builder-template .ast-pagination{padding:2em;}.ast-page-builder-template .entry-header.ast-no-title.ast-no-thumbnail{margin-top:0;}.ast-page-builder-template .entry-header.ast-header-without-markup{margin-top:0;margin-bottom:0;}.ast-page-builder-template .entry-header.ast-no-title.ast-no-meta{margin-bottom:0;}.ast-page-builder-template.single .post-navigation{padding-bottom:2em;}.ast-page-builder-template.single-post .site-content > .ast-container{max-width:100%;}.ast-page-builder-template.single-post .site-content > .ast-container{max-width:100%;}.ast-page-builder-template .entry-header{margin-top:4em;margin-left:auto;margin-right:auto;padding-left:20px;padding-right:20px;}.ast-page-builder-template .ast-archive-description{margin-top:4em;margin-left:auto;margin-right:auto;padding-left:20px;padding-right:20px;}.ast-page-builder-template.ast-no-sidebar .entry-content .alignwide{margin-left:0;margin-right:0;}.single.ast-page-builder-template .entry-header{padding-left:20px;padding-right:20px;}.ast-page-builder-template.ast-no-sidebar .entry-content .alignwide{margin-left:0;margin-right:0;}.ast-small-footer > .ast-footer-overlay{background-color:#0a0a0a;}.ast-small-footer a{color:#62aeec;}.ast-small-footer a:hover{color:#d32e15;}.footer-adv .footer-adv-overlay{border-top-style:solid;border-top-color:#7a7a7a;}.wp-block-buttons.aligncenter{justify-content:center;}@media (max-width:782px){.entry-content .wp-block-columns .wp-block-column{margin-left:0px;}}@media (max-width:768px){.ast-separate-container .ast-article-post,.ast-separate-container .ast-article-single{padding:1.5em 2.14em;}.ast-separate-container #primary,.ast-separate-container #secondary{padding:1.5em 0;}#primary,#secondary{padding:1.5em 0;margin:0;}.ast-left-sidebar #content > .ast-container{display:flex;flex-direction:column-reverse;width:100%;}.ast-author-box img.avatar{margin:20px 0 0 0;}}@media (min-width:769px){.ast-separate-container.ast-right-sidebar #primary,.ast-separate-container.ast-left-sidebar #primary{border:0;}.search-no-results.ast-separate-container #primary{margin-bottom:4em;}}.menu-toggle,button,.ast-button,.ast-custom-button,.button,input#submit,input[type="button"],input[type="submit"],input[type="reset"]{color:#fff;border-color:#1e73be;background-color:#1e73be;border-radius:2px;padding-top:10px;padding-right:40px;padding-bottom:10px;padding-left:40px;font-family:inherit;font-weight:inherit;}button:focus,.menu-toggle:hover,button:hover,.ast-button:hover,.ast-custom-button:hover .button:hover,.ast-custom-button:hover,input[type=reset]:hover,input[type=reset]:focus,input#submit:hover,input#submit:focus,input[type="button"]:hover,input[type="button"]:focus,input[type="submit"]:hover,input[type="submit"]:focus{color:#fff;background-color:#cd353a;border-color:#cd353a;}@media (min-width:544px){.ast-container{max-width:100%;}}@media (max-width:544px){.ast-separate-container .ast-article-post,.ast-separate-container .ast-article-single,.ast-separate-container .comments-title,.ast-separate-container .ast-archive-description{padding:1.5em 1em;}.ast-separate-container #content .ast-container{padding-left:.54em;padding-right:.54em;}.ast-separate-container .ast-comment-list li.depth-1{padding:1.5em 1em;margin-bottom:1.5em;}.ast-separate-container .ast-comment-list .bypostauthor{padding:.5em;}.ast-search-menu-icon.ast-dropdown-active .search-field{width:170px;}.site-branding img,.site-header .site-logo-img .custom-logo-link img{max-width:100%;}}@media (max-width:768px){.ast-mobile-header-stack .main-header-bar .ast-search-menu-icon{display:inline-block;}.ast-header-break-point.ast-header-custom-item-outside .ast-mobile-header-stack .main-header-bar .ast-search-icon{margin:0;}.ast-comment-avatar-wrap img{max-width:2.5em;}.ast-separate-container .ast-comment-list li.depth-1{padding:1.5em 2.14em;}.ast-separate-container .comment-respond{padding:2em 2.14em;}.ast-comment-meta{padding:0 1.8888em 1.3333em;}}.main-header-bar .button-custom-menu-item .ast-custom-button-link .ast-custom-button,.ast-theme-transparent-header .main-header-bar .button-custom-menu-item .ast-custom-button-link .ast-custom-button{font-family:inherit;font-weight:inherit;line-height:1;}.main-header-bar .button-custom-menu-item .ast-custom-button-link .ast-custom-button{background-color:#24cc63;border-radius:100px;border-style:solid;border-top-width:0px;border-right-width:0px;border-left-width:0px;border-bottom-width:0px;}.ast-theme-transparent-header .main-header-bar .button-custom-menu-item .ast-custom-button-link .ast-custom-button{border-style:solid;}@media (min-width:545px){.ast-page-builder-template .comments-area,.single.ast-page-builder-template .entry-header,.single.ast-page-builder-template .post-navigation,.single.ast-page-builder-template .ast-single-related-posts-container{max-width:1240px;margin-left:auto;margin-right:auto;}}body,.ast-separate-container{background-color:#fff;}@media (max-width:768px){.site-title{display:none;}.ast-archive-description .ast-archive-title{font-size:40px;}.site-header .site-description{display:none;}.entry-title{font-size:30px;}h1,.entry-content h1,.entry-content h1 a{font-size:30px;}h2,.entry-content h2,.entry-content h2 a{font-size:25px;}h3,.entry-content h3,.entry-content h3 a{font-size:20px;}.ast-single-post .entry-title,.page-title{font-size:30px;}}@media (max-width:544px){.site-title{display:none;}.ast-archive-description .ast-archive-title{font-size:40px;}.site-header .site-description{display:none;}.entry-title{font-size:30px;}h1,.entry-content h1,.entry-content h1 a{font-size:30px;}h2,.entry-content h2,.entry-content h2 a{font-size:25px;}h3,.entry-content h3,.entry-content h3 a{font-size:20px;}.ast-single-post .entry-title,.page-title{font-size:30px;}}@media (max-width:768px){html{font-size:85.5%;}}@media (max-width:544px){html{font-size:85.5%;}}@media (min-width:769px){.ast-container{max-width:1240px;}}@font-face{font-family:"Astra";src:url("https://cdn-bfgkc.nitrocdn.com/uiBoTKiXXMSqEHcArnGWYnghHPMTwKJS/assets/static/source/rev-35470d3/wp-content/themes/astra/assets/fonts/astra.woff") format("woff"),url("https://cdn-bfgkc.nitrocdn.com/uiBoTKiXXMSqEHcArnGWYnghHPMTwKJS/assets/static/source/rev-35470d3/wp-content/themes/astra/assets/fonts/astra.ttf") format("truetype"),url("https://cdn-bfgkc.nitrocdn.com/uiBoTKiXXMSqEHcArnGWYnghHPMTwKJS/assets/static/optimized/rev-35470d3/wp-content/themes/astra/assets/fonts/astra.svg#astra") format("svg");font-weight:normal;font-style:normal;font-display:swap;}@media (max-width:921px){.main-header-bar .main-header-bar-navigation{display:none;}}@media (min-width:769px){.single-post .site-content > .ast-container{max-width:1000px;}}.ast-desktop .main-header-menu.submenu-with-border .sub-menu,.ast-desktop .main-header-menu.submenu-with-border .astra-full-megamenu-wrapper{border-color:#f7f7f7;}.ast-desktop .main-header-menu.submenu-with-border .sub-menu{border-top-width:1px;border-right-width:1px;border-left-width:1px;border-bottom-width:1px;border-style:solid;}.ast-desktop .main-header-menu.submenu-with-border .sub-menu .sub-menu{top:-1px;}.ast-desktop .main-header-menu.submenu-with-border .sub-menu .menu-link,.ast-desktop .main-header-menu.submenu-with-border .children .menu-link{border-bottom-width:1px;border-style:solid;border-color:#f7f7f7;}@media (min-width:769px){.main-header-menu .sub-menu .menu-item.ast-left-align-sub-menu:hover > .sub-menu,.main-header-menu .sub-menu .menu-item.ast-left-align-sub-menu.focus > .sub-menu{margin-left:-2px;}}.ast-small-footer{border-top-style:solid;border-top-width:3px;border-top-color:#006edd;}.ast-small-footer-wrap{text-align:center;}.ast-header-break-point .main-navigation ul .button-custom-menu-item .menu-link{padding:0 20px;display:inline-block;width:100%;border-bottom-width:1px;border-style:solid;border-color:#eaeaea;}.button-custom-menu-item .ast-custom-button-link .ast-custom-button{font-size:inherit;font-family:inherit;font-weight:inherit;}.button-custom-menu-item .ast-custom-button-link .ast-custom-button:hover{transition:all .1s ease-in-out;}.ast-header-break-point.ast-header-custom-item-inside .main-header-bar .main-header-bar-navigation .ast-search-icon{display:none;}.ast-header-break-point.ast-header-custom-item-inside .main-header-bar .ast-search-menu-icon .search-form{padding:0;display:block;overflow:hidden;}.ast-header-break-point .ast-header-custom-item .widget:last-child{margin-bottom:1em;}.ast-header-custom-item .widget{margin:.5em;display:inline-block;vertical-align:middle;}.ast-header-custom-item .widget p{margin-bottom:0;}.ast-header-custom-item .widget li{width:auto;}.ast-header-custom-item-inside .button-custom-menu-item .menu-link{display:none;}.ast-header-custom-item-inside.ast-header-break-point .button-custom-menu-item .ast-custom-button-link{display:none;}.ast-header-custom-item-inside.ast-header-break-point .button-custom-menu-item .menu-link{display:block;}.ast-header-break-point.ast-header-custom-item-outside .main-header-bar .ast-search-icon{margin-right:1em;}.ast-header-break-point.ast-header-custom-item-inside .main-header-bar .ast-search-menu-icon .search-field,.ast-header-break-point.ast-header-custom-item-inside .main-header-bar .ast-search-menu-icon.ast-inline-search .search-field{width:100%;padding-right:5.5em;}.ast-header-break-point.ast-header-custom-item-inside .main-header-bar .ast-search-menu-icon .search-submit{display:block;position:absolute;height:100%;top:0;right:0;padding:0 1em;border-radius:0;}.ast-header-break-point .ast-header-custom-item .ast-masthead-custom-menu-items{padding-left:20px;padding-right:20px;margin-bottom:1em;margin-top:1em;}.ast-header-custom-item-inside.ast-header-break-point .button-custom-menu-item{padding-left:0;padding-right:0;margin-top:0;margin-bottom:0;}.astra-icon-down_arrow::after{content:"";font-family:Astra;}.astra-icon-close::after{content:"";font-family:Astra;}.astra-icon-drag_handle::after{content:"";font-family:Astra;}.astra-icon-format_align_justify::after{content:"";font-family:Astra;}.astra-icon-menu::after{content:"";font-family:Astra;}.astra-icon-reorder::after{content:"";font-family:Astra;}.astra-icon-search::after{content:"";font-family:Astra;}.astra-icon-zoom_in::after{content:"";font-family:Astra;}.astra-icon-check-circle::after{content:"";font-family:Astra;}.astra-icon-shopping-cart::after{content:"";font-family:Astra;}.astra-icon-shopping-bag::after{content:"";font-family:Astra;}.astra-icon-shopping-basket::after{content:"";font-family:Astra;}.astra-icon-circle-o::after{content:"";font-family:Astra;}.astra-icon-certificate::after{content:"";font-family:Astra;}.ast-breadcrumbs .trail-browse,.ast-breadcrumbs .trail-items,.ast-breadcrumbs .trail-items li{display:inline-block;margin:0;padding:0;border:none;background:inherit;text-indent:0;}.ast-breadcrumbs .trail-browse{font-size:inherit;font-style:inherit;font-weight:inherit;color:inherit;}.ast-breadcrumbs .trail-items{list-style:none;}.trail-items li::after{padding:0 .3em;content:"»";}.trail-items li:last-of-type::after{display:none;}.elementor-template-full-width .ast-container{display:block;}@media (max-width:544px){.elementor-element .elementor-wc-products .woocommerce[class*="columns-"] ul.products li.product{width:auto;margin:0;}.elementor-element .woocommerce .woocommerce-result-count{float:none;}}.ast-header-break-point .main-header-bar{border-bottom-width:3px;border-bottom-color:#dd1616;}@media (min-width:769px){.main-header-bar{border-bottom-width:3px;border-bottom-color:#dd1616;}}.ast-flex{-webkit-align-content:center;-ms-flex-line-pack:center;align-content:center;-webkit-box-align:center;-webkit-align-items:center;-moz-box-align:center;-ms-flex-align:center;align-items:center;}.main-header-bar{padding:1em 0;}.ast-site-identity{padding:0;}.header-main-layout-1 .ast-flex.main-header-container,.header-main-layout-3 .ast-flex.main-header-container{-webkit-align-content:center;-ms-flex-line-pack:center;align-content:center;-webkit-box-align:center;-webkit-align-items:center;-moz-box-align:center;-ms-flex-align:center;align-items:center;}.header-main-layout-1 .ast-flex.main-header-container,.header-main-layout-3 .ast-flex.main-header-container{-webkit-align-content:center;-ms-flex-line-pack:center;align-content:center;-webkit-box-align:center;-webkit-align-items:center;-moz-box-align:center;-ms-flex-align:center;align-items:center;}.main-header-menu .sub-menu .menu-item.menu-item-has-children > .menu-link:after{position:absolute;right:1em;top:50%;transform:translate(0,-50%) rotate(270deg);}.ast-header-break-point .main-header-bar .main-header-bar-navigation .page_item_has_children > .ast-menu-toggle::before,.ast-header-break-point .main-header-bar .main-header-bar-navigation .menu-item-has-children > .ast-menu-toggle::before,.ast-mobile-popup-drawer .main-header-bar-navigation .menu-item-has-children>.ast-menu-toggle::before,.ast-header-break-point .ast-mobile-header-wrap .main-header-bar-navigation .menu-item-has-children > .ast-menu-toggle::before{font-weight:bold;content:"";font-family:Astra;text-decoration:inherit;display:inline-block;}.ast-header-break-point .main-navigation ul.sub-menu .menu-item .menu-link:before{content:"";font-family:Astra;font-size:.65em;text-decoration:inherit;display:inline-block;transform:translate(0,-2px) rotateZ(270deg);margin-right:5px;}.widget_search .search-form:after{font-family:Astra;font-size:1.2em;font-weight:normal;content:"";position:absolute;top:50%;right:15px;transform:translate(0,-50%);}.astra-search-icon::before{content:"";font-family:Astra;font-style:normal;font-weight:normal;text-decoration:inherit;text-align:center;-webkit-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale;}.main-header-bar .main-header-bar-navigation .page_item_has_children > a:after,.main-header-bar .main-header-bar-navigation .menu-item-has-children > a:after,.site-header-focus-item .main-header-bar-navigation .menu-item-has-children > .menu-link:after{content:"";display:inline-block;font-family:Astra;font-size:.6rem;font-weight:bold;text-rendering:auto;-webkit-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale;margin-left:10px;line-height:normal;}.ast-mobile-popup-drawer .main-header-bar-navigation .ast-submenu-expanded>.ast-menu-toggle::before{transform:rotateX(180deg);}.ast-header-break-point .main-header-bar-navigation .menu-item-has-children > .menu-link:after{display:none;}@font-face{font-family:eicons;src:url("https://cdn-bfgkc.nitrocdn.com/uiBoTKiXXMSqEHcArnGWYnghHPMTwKJS/assets/static/source/rev-35470d3/wp-content/plugins/elementor/assets/lib/eicons/fonts/487fb88d73d41a26c611d95e94cc95a3.eicons.eot");src:url("https://cdn-bfgkc.nitrocdn.com/uiBoTKiXXMSqEHcArnGWYnghHPMTwKJS/assets/static/source/rev-35470d3/wp-content/plugins/elementor/assets/lib/eicons/fonts/487fb88d73d41a26c611d95e94cc95a3.eicons.eot#iefix") format("embedded-opentype"),url("https://cdn-bfgkc.nitrocdn.com/uiBoTKiXXMSqEHcArnGWYnghHPMTwKJS/assets/static/source/rev-35470d3/wp-content/plugins/elementor/assets/lib/eicons/fonts/487fb88d73d41a26c611d95e94cc95a3.eicons.woff2") format("woff2"),url("https://cdn-bfgkc.nitrocdn.com/uiBoTKiXXMSqEHcArnGWYnghHPMTwKJS/assets/static/source/rev-35470d3/wp-content/plugins/elementor/assets/lib/eicons/fonts/487fb88d73d41a26c611d95e94cc95a3.eicons.woff") format("woff"),url("https://cdn-bfgkc.nitrocdn.com/uiBoTKiXXMSqEHcArnGWYnghHPMTwKJS/assets/static/source/rev-35470d3/wp-content/plugins/elementor/assets/lib/eicons/fonts/487fb88d73d41a26c611d95e94cc95a3.eicons.ttf") format("truetype"),url("https://cdn-bfgkc.nitrocdn.com/uiBoTKiXXMSqEHcArnGWYnghHPMTwKJS/assets/static/optimized/rev-35470d3/wp-content/plugins/elementor/assets/lib/eicons/fonts/487fb88d73d41a26c611d95e94cc95a3.eicons.svg#eicon") format("svg");font-weight:400;font-style:normal;font-display:swap;}