I have several Excel files in the same file folder. They are all set to automatically update web import data when they are opened.
I will be away from my computer for several days soon. I need a Macro I can put in a new Excel file (within the same folder) that will automatically open each (listed) file, wait about 30 seconds for the data to Refresh-All in that file, then save the file with "Today's Date" added to the end of the new file, then open the next file and do the same until all listed files are completed. I will leave that one file running while I'm away.
I would like it to ask me for the file names to open, how many seconds to wait before saving and closing, and what time to start each day.

Thanks!
Bret