This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
@echo off | |
wmic product get caption,version > %~dp0/n.txt | |
echo finish! | |
pause > nul |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub FormatearNotas() | |
Dim tbl As Table | |
Dim i As Integer | |
Dim celda As Cell | |
For Each tbl In ActiveDocument.Tables | |
For i = 3 To tbl.Rows.Count | |
On Error Resume Next | |
Set celda = tbl.Cell(i, 4) | |
celda.VerticalAlignment = wdCellAlignVerticalCenter | |
With celda.Range |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub EliminarNoNumerosOAusenteEnNotas() | |
Dim tbl As Table | |
Dim i As Integer | |
Dim rng As Range | |
Dim regex As RegExp | |
Set regex = CreateObject("VBScript.RegExp") | |
With regex | |
.Global = True | |
.IgnoreCase = False | |
.Pattern = "[^\d]" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub FormatearInformeCualitativo() | |
Dim tbl As Table | |
Dim i As Integer | |
Dim celda As Cell | |
For Each tbl In ActiveDocument.Tables | |
For i = 1 To 2 | |
Set celda = tbl.Cell(i, 3) | |
With celda.Range.ParagraphFormat | |
' Establecer sangría a cero | |
.LeftIndent = 0 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub FormatearArea() | |
Dim tbl As Table | |
Dim fila As Integer | |
Dim col As Integer | |
Dim textoCelda As String | |
Dim regex1 As Object | |
Set regex1 = CreateObject("VBScript.RegExp") | |
With regex1 | |
.Global = False | |
.IgnoreCase = False |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub FormatearAsignatura() | |
Dim tbl As Table | |
Dim fila As Integer | |
Dim col As Integer | |
Dim textoCelda As String | |
Dim regex As Object | |
For Each tbl In ActiveDocument.Tables | |
On Error Resume Next | |
For Each celda In tbl.Columns(2).Cells | |
With celda.Range.ParagraphFormat |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub DividirCeldas() | |
Dim tbl As Table | |
Dim row As row | |
Dim regex As Object | |
Dim cellText As String | |
Dim i As Byte | |
Dim countDel As Byte | |
countDel = 0 | |
Set regex = CreateObject("VBScript.RegExp") | |
regex.IgnoreCase = False |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub EliminarFilasConPresencialidad() | |
Dim tbl As Table | |
Dim row As row | |
Dim regex As Object | |
Dim cellText As String | |
Dim i As Byte | |
Dim countDel As Byte | |
countDel = 0 | |
Set regex = CreateObject("VBScript.RegExp") | |
regex.IgnoreCase = False |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub AlinearVerticalTablas() | |
Dim tbl As Table | |
Dim celda As Cell | |
For Each tbl In ActiveDocument.Tables | |
For Each celda In tbl.Range.Cells | |
celda.VerticalAlignment = wdCellAlignVerticalCenter | |
Next celda | |
Next tbl | |
End Sub | |
Sub FormatearAsignatura() |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# obtener los servicios | |
# listar sus nombres y nombre de proveedor | |
write-host "hola mundo" | |
$bloatware = @( | |
"Microsoft.BingWeather", | |
"Microsoft.BingFinance", | |
"Microsoft.GetHelp", | |
"Microsoft.Getstarted", | |
) | |
get-appxpackage | where-object NonRemovable -eq $False |
NewerOlder