Declare Function Backup Lib "Kernel32" Alias "CopyFileA" _
(ByVal lpexistingfilename As String, ByVal lpnewfilename As String, ByVal bfailifexists As Long) As Long Rem Esta linea va en un modulo
Backup_DB RutaOrigen, RutaDestino
Sub Backup_DB(strDBActual As String, strDBBackup As String) Rem Este es tambien va en un modulo
Dim Result As Long
If Dir(strDBActual) = "" Then
MsgBox Chr(34) & RutaDestino & Chr(34) & ". Este no es un nombre valido."
Else
Result = Backup(RutaOrigen, RutaDestino, False)
End If
End Sub