tag:blogger.com,1999:blog-50086250788739687012024-03-13T20:13:04.197-05:00Todo Sobre ExcelBlog para aprender más sobre Excel y VBA. De Abraham Valencia. Lima, Perú.Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.comBlogger132125tag:blogger.com,1999:blog-5008625078873968701.post-20822589699753351732023-07-01T20:05:00.006-05:002024-02-26T20:07:18.448-05:00Conectando Excel a bases de datos: 6- Importar registros de Access a Excel usando Where<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Conectando Excel a bases de datos: 6- Importar registros de Access a Excel usando Where</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/WvcVrlVRLq8?si=qM4brBE_25K3XrDW" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-70227576916324190992023-06-22T20:00:00.008-05:002024-02-26T20:03:49.194-05:00Curso Excel y VSTO: 12 –Importar datos de Access desde Excel usando System.Data.OleDb<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Curso Excel y VSTO: 12 –Importar datos de Access desde Excel usando System.Data.OleDb</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/DBfY9Hz01BU?si=sZSk0s5sJYHLI20B" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-76666486681326531182023-05-27T20:44:00.002-05:002023-12-26T20:47:47.750-05:00Conectando Excel a bases de datos: 5- Registros hacia Access con VBA, ADO y SQL (bucles y arrays)<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Conectando Excel a bases de datos: 5- Registros hacia Access con VBA, ADO y SQL (bucles y array</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/98wygkQM1xU?si=KxNXTOozbiKqe7XM" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-85473124006372186642023-04-30T16:50:00.003-05:002023-11-18T16:52:20.952-05:00¿Power BI nació de Microsoft Excel?<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">¿Power BI nació de Microsoft Excel?</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/ldZB7na7SUU?si=C8NduSzJJMRxLU_z" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-59538763125367401222023-04-24T00:18:00.007-05:002023-07-05T00:20:04.511-05:00¿VBA o TypeScript? He ahí el dilema<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">¿VBA o TypeScript? He ahí el dilema</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/-uwXK2Ny9lI" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-69775604114071650632023-04-15T00:14:00.006-05:002023-07-05T00:16:32.483-05:00Curso Excel y VSTO: 11 –Ingresar datos con un Windows Form que incluya un DateTimePicker<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Curso Excel y VSTO: 11 –Ingresar datos con un Windows Form que incluya un DateTimePicker</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/fA3RxQzbRTw" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-72293801162968146482023-03-23T22:30:00.006-05:002023-04-28T22:32:58.302-05:00Curso Excel y VSTO: 10 – Los Datagridview y sus formatos (I)<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Curso Excel y VSTO: 10 – Los Datagridview y sus formatos (I)</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/6iBjINrqQYU" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-65996215185853978132023-03-16T22:19:00.006-05:002023-04-28T22:22:50.291-05:00Conectando Excel a bases de datos: 4- Enviando registros hacia Access con VBA, ADO y SQL<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Conectando Excel a bases de datos: 4- Enviando registros hacia Access con VBA, ADO y SQL</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/PS2oExCtiB8" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-72196181553101840932023-03-10T11:10:00.002-05:002023-03-18T11:12:35.567-05:00¿Existe un "Excel de Google"? ¿Google Drive trabaja con Excel?<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">¿Existe un "Excel de Google"? ¿Google Drive trabaja con Excel?. ¡No dejes de verlo!</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/Qkhqk2vHCqU" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-8170664638302964132023-03-04T09:21:00.003-05:002023-03-18T09:22:37.142-05:00Conectando Excel a bases de datos: 3- Conectándonos con SQL Server Express<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Conectando Excel a bases de datos: 3- Conectándonos con SQL Server Express. ¡No dejes de verlo!</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/ASXutqO4dJU" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-86849850590999367062023-03-01T09:11:00.005-05:002023-03-18T09:13:16.519-05:00Conectando Excel a bases de datos: 2- Conectándonos con MySQL (Local y web)<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Conectando Excel a bases de datos: 2- Conectándonos con MySQL (Local y web). ¡No dejes de verlo!</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/oPLWk-AmihU" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-25577192111388161912023-02-25T08:54:00.002-05:002023-03-18T09:13:46.217-05:00Conectando Excel a bases de datos: 1- Distintos modos de conectarse con Microsoft Access<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Conectando Excel a bases de datos: 1- Distintos modos de conectarse con Microsoft Access. ¡No dejes de verlo!</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/_G1ASuGgLVA" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-25902934726874514842023-02-19T08:50:00.002-05:002023-03-18T08:52:45.349-05:00Curso Excel y VSTO: 9 – Usando matrices<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Curso Excel y VSTO: 9 – Usando matrices. ¡No dejes de verlo!</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/o1M1U3Rd9WI" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-56.450403432833852 -147.355254 32.357657232833859 -6.7302540000000022tag:blogger.com,1999:blog-5008625078873968701.post-48548702724668266292023-02-07T19:06:00.003-05:002023-02-25T20:03:14.962-05:00Curso Excel y VSTO: 8 - Creando un instalador para nuestra automatización (I)<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Curso Excel y VSTO: 8 - Creando un instalador para nuestra automatización (I). ¡No dejes de verlo!</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/IKuTjWkiI7U" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0tag:blogger.com,1999:blog-5008625078873968701.post-72691025016370881162023-02-04T18:39:00.005-05:002023-02-25T18:41:00.401-05:00Curso Excel y VSTO: 7 - Usando SELECT - CASE<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Curso Excel y VSTO: 7 - Usando SELECT - CASE. ¡No debes perdértelo!</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/KuycZ9XNK9k" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0tag:blogger.com,1999:blog-5008625078873968701.post-67553517212061069902023-01-27T23:27:00.003-05:002023-01-28T17:16:53.778-05:00Curso Excel y VSTO: 6 - El uso de FOR - NEXT y FOR EACH<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Curso Excel y VSTO: 6 - El uso de FOR - NEXT y FOR EACH. ¡No debes perdértelo!</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/C-QmoLfrnBQ" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0tag:blogger.com,1999:blog-5008625078873968701.post-74650759179684668982023-01-25T23:35:00.010-05:002023-01-27T23:42:55.944-05:00Curso Excel y VSTO: 5- Tipo de datos, el uso de WITH y cómo usar IF (OR y AND)<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Curso Excel y VSTO: 5- Tipo de datos, el uso de WITH y cómo usar IF (OR y AND). ¡No debes perdértelo!</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/bEz8HQCN3Qo" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0tag:blogger.com,1999:blog-5008625078873968701.post-69940552189438405302023-01-03T00:14:00.001-05:002023-01-28T00:16:58.343-05:00Microsoft Office Specialist: Excel 2019 Expert<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Me certifiqué y quiero compartirlo con ustedes y además agradecer públicamente a mi querido amigo Sergio Alejandro Campos de @SergioAlejandroCampos, así como a Eric Heredia por el curso de preparación que brindan y al que asistí.</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/gV_EdQWa8To" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0tag:blogger.com,1999:blog-5008625078873968701.post-82230261533975941982022-12-31T23:30:00.008-05:002023-01-01T23:33:42.848-05:00¡Feliz año 2023!<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Mis mejores deseos para todos y todas en este nuevo año 2023.</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/gV_EdQWa8To" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-10458895484066088972022-12-22T23:11:00.007-05:002023-01-01T23:14:38.674-05:00Curso Excel y VSTO: 4- El objeto Worksheet (Propiedades y eventos)<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Capítulo 4 del Curso VSTO. El objeto Worksheet (Propiedades y métodos). ¡No puedes perdértelo!</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/a9861JiZ6qw" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-40.356606936178849 -112.199004 16.263860736178845 -41.886504tag:blogger.com,1999:blog-5008625078873968701.post-6687636613392855002022-12-10T16:05:00.001-05:002022-12-10T16:05:25.611-05:00Capítulo 3 del Curso VSTO. El objeto Range (Propiedades y métodos). <html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Hoy continuamos con el capítulo 3 del curso sobre Excel y VSTO. En este capítulo vamos a comenzar con los códigos que tanto estaban esperando y hemos elegido trabajar con el objeto Range, algunas de sus propiedades y sus métodos más conocidos ¡No puedes perdértelo!</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/8kpCNblQYt0" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<p align="justify">¡Saludos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0Lima, Perú-12.0463731 -77.042754-26.943814639108979 -94.620879 2.85106843910898 -59.464629tag:blogger.com,1999:blog-5008625078873968701.post-3588415837099982012022-11-14T23:47:00.002-05:002022-11-14T23:47:28.961-05:00Curso Excel y VSTO: 2- Primeros conceptos (Clases y objetos)<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Capítulo 2 del Curso VSTO. Primeros conceptos (Clases y objetos).</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/CF3Z2yE00i4" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<p align="justify">¡Nos vemos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0tag:blogger.com,1999:blog-5008625078873968701.post-45780822740409781782022-11-09T23:42:00.002-05:002022-11-14T23:47:57.612-05:00Curso Excel y VSTO: 1- Introducción teórica<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Capítulo 1 del Curso VSTO. Hoy comenzamos con la introducción teórica sobre las VSTO.?</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/IZ5zeXEu83c" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<p align="justify">¡Nos vemos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0tag:blogger.com,1999:blog-5008625078873968701.post-18435770015100907432022-11-04T21:21:00.004-05:002022-11-06T21:23:31.013-05:00¡Un adelanto de lo que se viene! ¿Un control Date Time and Picker en Excel de 64 bits?<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">¡Un adelanto de lo que se viene! ¿Un control Date Time and Picker en Excel de 64 bits funcionado de modo correcto? ¿Es eso posible?</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/arXOV_nB18Q" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<p align="justify">¡Nos vemos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0tag:blogger.com,1999:blog-5008625078873968701.post-74558374314502467562022-11-03T23:00:00.003-05:002022-11-03T23:00:32.418-05:00Automatizando Excel (X): El complemento Script Lab (4) - Enviando datos a través de un formulario<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta>
<style type="text/css">
.ArialF {
font-family: Arial;
}
.ArialF {
font-family: Arial;
font-size: 13px;
}
body,td,th {
font-size: 12px;
font-family: Arial;
}
</style>
<style type="text/css">
<!--
table.MsoNormalTable {
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:8.0pt;
margin-left:0cm;
line-height:107%;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
-->
</style>
</head>
<body class="ArialF">
<div align="justify">
<p align="justify">Seguimos con el uso del complemento Script Lab, esta vez veremos cómo enviar datos a la hoja a través de un formulario hecho con HTML.</p>
<p align="center">
<iframe width="560" height="315" src="https://www.youtube.com/embed/tAuSv5TVlFk" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<p align="justify">¡Nos vemos!</p>
</div>
<p><strong>Abraham Valencia</strong><br>
Lima, Perú
</p>
</body>
</html>Abraham Valenciahttp://www.blogger.com/profile/14915775809644771973noreply@blogger.com0