run macro from closed workbook automatically for every 24 hours

[punna111]

Hi all,

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,
PRB.

[shrivallabha]

Cross posted on MrExcel:
http://www.mrexcel.com/forum/excel-q...-24-hours.html