Opening book details…
Can I read Excel Macro to Create Monthly Workbooks on EtoBox?
Excel Macro to Create Monthly Workbooks by Dev Sri is a document available to read on EtoBox.
What is Excel Macro to Create Monthly Workbooks about?
This macro creates 12 workbooks, one for each month of the year, in the same folder. It prompts the user to enter a year and then generates individual worksheets for each day of each month. Existing files will be overwritten if the user selects "YES" when prompted. The macro code can be viewed by pressing Alt+F11 in the Visual Basic Editor.
- Author
- Dev Sri
- Language
- EN