Hello All,
Please if this question has been asked before kindly direct me to the solution, else please do assist.
I need to do a VBA to creat a folder and copy some specific files to the new folder. I have achieved creating the folder but to copy files to it is my trouble.
See below the code I have put together and it's not solving my problem.


Sub folder()
Dim strPath As String
Dim SourceFile, DestinationFile
' creating folder
strPath = InputBox("Enter folder Name", "Create Folder")
MkDir "C:\CLass\" & strPath
'Copying files
SourceFile = "C:\board\xxx.xls"
DestinationFile = "C:\CLass\" & strPath
End Sub