I have been scouring the web and forums and am unable to find anything to my issue. I am in need of a way to push a button on a form and have it copy all files and folders in one location and then essentially paste (generic MS term I know) them to another location. The only way I know how to do this is essentially using:
If Dir("C:\Folderlocationtocheck") = "" Then
MkDir ("C:\Createmissingfolder\")
End If
to create each and every single folder in the new location then using:
FileSystemObject.CopyFile "c:\oldfilelocation\*.*", "c:\newfilelocation\"
However, the problem is this takes way to much time to setup as I have to map out each folder and file location to get them to copy over. There is also the problem that new files and folders are created and without including them in the cumbersome way I currently know how to do this then they would never be copied when they are needed to be. Any ideas on this problem? The only things I have found so far are partial ideas that some folks have had, but it seems as though they gave up without a solution or guidance to their questions.
If Dir("C:\Folderlocationtocheck") = "" Then
MkDir ("C:\Createmissingfolder\")
End If
to create each and every single folder in the new location then using:
FileSystemObject.CopyFile "c:\oldfilelocation\*.*", "c:\newfilelocation\"
However, the problem is this takes way to much time to setup as I have to map out each folder and file location to get them to copy over. There is also the problem that new files and folders are created and without including them in the cumbersome way I currently know how to do this then they would never be copied when they are needed to be. Any ideas on this problem? The only things I have found so far are partial ideas that some folks have had, but it seems as though they gave up without a solution or guidance to their questions.