vamshikrishna
What is connection with 'delete a macro' and 'I have build some marco...'?
...
Could You run it that specific date?
or
Could it run ONLY in that specific date?
If you need to run it on schedule or on specific date...
Personally, I'd just use VBS file (which will open specific Excel file and run the macro stored within). And use Task Scheduler to run the VBS on schedule.