Execute a macro in a closed workbook, or open and execute without the user noticing

You could use the Windows Scheduler to launch a Macro Enabled Workbook with a Workbook Open event handler.

The event handler could, in turn, launch your macro which would, as a last action, (save and) close the workbook.


Regards, TMS

Exactly -

I do this with task scheduler as TMS described, would run it at 9:59 and then inside "This Workbook" put this

Please Login or Register  to view this content.

MacroName would call on the macro in your module that would run the macro you desire. Now this will NOT go unnoticed by the user - they will see an instance of excel open up. At most you can disable screen updating in the application which would allow the macro to run quickly but not flip back and forth between tasks, but the user will know there is a file open and will cause errors should they start clicking all over the place attempting to take control... Best to do on a remote PC or when you know no one will be on. And of course you can do Workbook close or Application Quit depending on if you want excel to remain open or to shut down completely...

Cheers

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.