DataBlake
Well-known Member
- Joined
- Jan 26, 2015
- Messages
- 781
- Office Version
- 2016
- Platform
- Windows
I'm looking for a way to insert an entire sheet from whatever the most recent xlsx file is from a specific folder location
so lets say theres 3 xlsx files in "C:\Users\bsnyder\Desktop\Excel Program\backups"
i would want it to automatically insert a sheet with the data of the first sheet of the most recent file.
I will be repeating this process for 6 different files so if there is a more efficient way you can think of i'd love to know what you have in mind (like looking in one folder for the 6 files).
any help would be appreciated.
so lets say theres 3 xlsx files in "C:\Users\bsnyder\Desktop\Excel Program\backups"
i would want it to automatically insert a sheet with the data of the first sheet of the most recent file.
I will be repeating this process for 6 different files so if there is a more efficient way you can think of i'd love to know what you have in mind (like looking in one folder for the 6 files).
any help would be appreciated.