I have a file which is having name as "Team data-11/23/2012"
actually i have to create a file on daily basis except Saturday and Sunday.
I need a macro which automatically runs from one file and saves the excel file on daily basis. and the file name should "team data - (today's date)". this file also should be created automatically. it means that macro should run automatically for every 24 hours.
any help highly appreciated...
Thanks & Regards,