I wouldn't use excel for this because it ties up Excel,
and it eats up CPU cycles.

Instead, I would write a VBScript and set it up
as a scheduled task to run every 10 minutes.
You can even have it only run during certain time of day.
Also, you can even write to a log file every time it runs
so that you can check the log at any time.