abishop2022
New Member
- Joined
- Apr 11, 2022
- Messages
- 8
- Office Version
- 2016
- Platform
- Windows
I have a workbook that is updated daily (deleted and replaced with new workbook). I would like to be able to create a macro that runs on a schedule to format this new workbook after it is created. I looked into this and I started by creating a "MacroWorkbook.xlsm" and copying the sheet that I want to format from the new workbook over to the MacroWorkbook.xlsm and then created a macro with the specific formatting I need.
How do I manage to schedule this macro to run on the new workbook?
How do I manage to schedule this macro to run on the new workbook?