PDA

View Full Version : run macro from closed workbook automatically for every 24 hours



punna111
11-24-2012, 05:12 AM
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...:help


Thanks & Regards,
PRB. :bow::whip

shrivallabha
11-24-2012, 11:55 PM
Cross posted on MrExcel:
http://www.mrexcel.com/forum/excel-questions/671005-run-macro-closed-workbook-automatically-every-24-hours.html