Every morning, I have a macro automatically run that updates a few history files. Each history file is large, so they must be split up by month. I'm spoiled by the Application.OnTime function everyday and don't want to have to make new history files each month. Is there a way to create new history files on the first of every month? The file would be basic, just the column headers and the "...Summary 2020-MM.xlsx" filename.