Would someone please remind me how to import an excel file that's located in a folder that has a different name each day.
I have to import 4 different excel files each day.
Each day the file names are different, except for one word in the file name (Work, Home, Time)
Becuase in the past the files have been manually opened then modified and resaved in the same folder, there are hundreds of these types of excel files, but I only need the ones created the same day.
What would be the easiest way for me to import these files while but clicking a button or hitting run also using the system date for today's date? Macro or VBA
Thank you for your help
I have to import 4 different excel files each day.
Each day the file names are different, except for one word in the file name (Work, Home, Time)
Becuase in the past the files have been manually opened then modified and resaved in the same folder, there are hundreds of these types of excel files, but I only need the ones created the same day.
What would be the easiest way for me to import these files while but clicking a button or hitting run also using the system date for today's date? Macro or VBA
Thank you for your help