Código: Seleccionar todo
Public Sub Registrarpuntualidad()
Dim registros As Long
Dim nombreregistro As String
Application.ScreenUpdating = False
nombreregistro = "C:\Users\guillermo.blandon\Documents\Registro Puntualidad.xls"
Workbooks.Open nombreregistro
registros = Range("AA1").Value
Range("A2").Offset(registros, 0).FormulaR1C1 = "=NOW()"
Range("A2").Offset(registros, 0).Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A2").Offset(registros, 1).FormulaR1C1 = ThisWorkbook.Path
Range("A2").Offset(registros, 2).FormulaR1C1 = "=MID(MID(RC[-1],FIND(""\Users\"",RC[-1])+LEN(""\Users\""),100),1,FIND(""\"",MID(RC[-1],FIND(""\Users\"",RC[-1])+LEN(""\users\""),100))-1)"
Range("A2").Offset(registros, 2).Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A2").Offset(registros, 3).FormulaR1C1 = "=IF(TEXT(RC[-3],""hh:mm"")*1<R1C10,""Entrada"",""Salida"")"
Range("A2").Offset(registros, 3).Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveWorkbook.Close True
Windows("Puntualidad").Activate
Application.ScreenUpdating = True
MsgBox "Registro Realizado Satisfactoriamente"
ActiveWorkbook.Close False
End Sub