I want to write a code that either opens excel or a workbook in excel and runs my code at a certain time everyday of the week (the computer will stay on). Please let me know if you have an idea on how to do this. I would prefer to not have to open up Excel at all if at all possible. Thanks so much.
Use TaskScheduler to run the workbook and place some code in your workbook open event to run the macro.
One down side to this is you will have to set macro security to low or else you will have the macro dialog box show when opening the workbook.
Reafidy.
Tip: When using code and disabling events/screen updates/calculation be sure to use an error handler to turn them back on if an error occurs.
What are you trying to acheive anyway?
I have an automated report that has to run 7 days a week at 2am. Where is taskscheduler? And will that allow me to open and close excel or just a workbook in excel and am I able to set a time for the code to run using that? Thanks so much
You can use task scheduler to open either a workbook in excel or excel on its own.
Task scheduler is found under start - programs - accessories - system tools
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks