Is there a way to automatically open an excel file every day at 6:00 am and print it out ? Is it possible to do this in a macro somehow or is something more advanced like visual basic required ?
You could use the Windows Task Scheduler to launch the worksheet every moring at 6:00 (or whatever schedule you want) and then use the Workbook_Open event to do whatever you need with VBA.
When setting up the task, don't be put off by Windows asking for a program name. You can just type the fully qualified .xls file name and it will work just fine. (Assuming you have the normal file association set up.)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.