If you're accepting user input for folder paths, you might need to check for trailing backslashes (\) before building a file path. The FSO.BuildPath method makes this simpler:
Const sourceFilePath As String = "C:\Temp" '<-- Without trailing backslash
Const targetFilePath As Strin...