With VBA excel code: I was wondering if it is possible to select a folder and a sub folder with its files and copy and paste it to another place?
With VBA excel code: I was wondering if it is possible to select a folder and a sub folder with its files and copy and paste it to another place?
Yes
1. Variant with such commands as:
FileCopy source, destination; Name oldpathname As newpathname
MkDir path; Dir (pathname, attributes)
ChDrive drive; ChDir path; CurDir drive
Kill pathname; RmDir path
2. Variant with FSO (Scripting.FileSystemObject)
3. Variant with Shell command and 'xcopy' or 'robocopy'
e.g. Variant 2:
But it has limitations that can cause errors when copying.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks