Rutherford
New Member
- Joined
- Jul 5, 2017
- Messages
- 1
Hello,
I am a beginner to VBA, and I am currently trying to create a macro which takes data from a central folder (e.g. "7_5_2017_DatasetA.xls" will be dropped in a folder with revised information from the last entry "6_5_2017_DatasetA.xls") and pastes it into a centralized folder. However, this folder will have many different datasets which are all updated at different times. I would like the macro to run through each of the datasets to find, check if there is a more recent version, and copy and paste the information (if there is a more recent version).
How would you all recommend going about that?
I am a beginner to VBA, and I am currently trying to create a macro which takes data from a central folder (e.g. "7_5_2017_DatasetA.xls" will be dropped in a folder with revised information from the last entry "6_5_2017_DatasetA.xls") and pastes it into a centralized folder. However, this folder will have many different datasets which are all updated at different times. I would like the macro to run through each of the datasets to find, check if there is a more recent version, and copy and paste the information (if there is a more recent version).
How would you all recommend going about that?
