| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CREATING NEW WORKBOOK FILE EVERY MONTH AND NEW WORKSHEET EVERY DATE
Hi friends,
How i can make vba code who can create every 1st date of month new file, with name of month (ex. "data_may_05.xls") and to add every date (or date who used in range A1) a worksheet with the day as name (ex 09/05/2005 to give "09" as name in worksheet). Thanks Mike Sofianos |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CREATING NEW WORKBOOK FILE EVERY MONTH AND NEW WORKSHEET EVERY DAT
I would be interested in this too.How to create a new workbook at the
beginning of each month based on an existing template. Would it be eaiser to do this based on a time event or to create a new file in the event that the correct file is not present. -- tia Paul "michael sofianos" wrote: Hi friends, How i can make vba code who can create every 1st date of month new file, with name of month (ex. "data_may_05.xls") and to add every date (or date who used in range A1) a worksheet with the day as name (ex 09/05/2005 to give "09" as name in worksheet). Thanks Mike Sofianos |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I set a file to auto-open and save at each month begin date? | Excel Discussion (Misc queries) | |||
| Creating a new file for each excel worksheet | Excel Discussion (Misc queries) | |||
| Creating Reports in another worksheet in a workbook | Excel Discussion (Misc queries) | |||
| Creating Linked Workbook file name using cell variables | Excel Worksheet Functions | |||
| creating new workbook from single worksheet | Excel Programming | |||
Linear Mode
