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

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