View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
michael sofianos michael sofianos is offline
external usenet poster
 
Posts: 2
Default 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