Steps to schedule a macro to run daily automatically with sample code & setup scripts. Try this and test run by scheduling any VBA macro run automatically
Read this post on officetricks.com