Import 4 Different Excel Files from One Folder


Dec 17, 2010
Reaction score
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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question