Okay so I have tried my hand at typing some VBA and below is what I have found after doing a few days of googling.
Old File is the textbox that contains the Full Path to the file.
New File is the textbox that contains the path to the new folder where I want the file to go.
But I can't get it to work. Any Help?
Old File is the textbox that contains the Full Path to the file.
New File is the textbox that contains the path to the new folder where I want the file to go.
Code:
Private Sub Command24_Click()
Dim OldFile As String
Dim NewFile As String
Set OldFile = Forms!frmAddDocument!txtLink.Value = ""
Set NewFile = Forms!frmAddDocument!Text22.Value = ""
FileCopy OldFile, NewFile
End Sub
But I can't get it to work. Any Help?