Hi,
I am trying to automate the manual file saving process through VBA, Any help would be greatly appreciated.
Part 1 : Copying from the source.
I have 3 master folder(ABC, XYZ & PQR) each contains 2 sub folders (Mandatory documents & Optional documents). I want an option for user to select Master file name and sub folder name, Which will be the source to copy the files which are in sub folders.
Part 2: Paste to destination.
There are 1000+ folders in a path, Each folder name starts with unique 6 digit number. I want an option for user to input the 6-digit unique number which will be the destination folder to paste the copied files.
please help me to save time and effort of doing the monotonous job.
I am trying to automate the manual file saving process through VBA, Any help would be greatly appreciated.
Part 1 : Copying from the source.
I have 3 master folder(ABC, XYZ & PQR) each contains 2 sub folders (Mandatory documents & Optional documents). I want an option for user to select Master file name and sub folder name, Which will be the source to copy the files which are in sub folders.
Part 2: Paste to destination.
There are 1000+ folders in a path, Each folder name starts with unique 6 digit number. I want an option for user to input the 6-digit unique number which will be the destination folder to paste the copied files.
please help me to save time and effort of doing the monotonous job.