VB Code from Copying from a to b

[DaveXP]

Hey, can anyone tell me wat the code is to make a button which can copy files from one place to another

Thanks

[jdoe]

Private Sub Command1_Click()
  Dim fso As Object
  
  Set fso = CreateObject("Scripting.FileSystemObject")
  fso.CopyFile "C:\*.TXT", "D:\DESTINATION\"

End Sub