Automatic-run Excel macros

Since the start of my life with computers back in 1993 (Yes, I am that old) I always was fascinated by the fact of automation.

A tool, or a machine that does things on its own, even decide what to do and when to do it.

First it was when using peek and poke in NEC PC-6001, then "Autoexec.bat" when I first jumped to DOS, then "Autorun.inf", and so on

So, when I got introduced to Microsoft Excel back in 1997 (Again, I know, I am old, back to the subject here) my passion did not changed, just got evolved or delayed since my first years were for learning only.

So in 2011, when I reached the point of saying that I have a good grip on Excel and VBA, I went ahead and applied this type of automation into Excel-macro-type

And here is the tool that I am using on daily basis, it is a small Excel-macro xlsm workbook that will run any macro in any Excel file, then close when done

At first I used it in some of my Server-based-tools when I was working in EA back in 2011 and 2012, then when a chance arises, I tried to make excuses to use it and add it to my list of tools

What the tool does is that once it is open, it runs certain macro from certain Excel file setup by user. Then when that macro is done, it closes that file after save, closes the autorun macro without saving, then exit

The only challenge was how to call that Excel file, double-click is always an option, but it wouldn't be complete automation if user has to double-click, right?

The I tried "scheduled tasks" in Windows I got the limitation of user privileges and password-related especially when my plans were to run it on a 24/7 machine, any machine.

So, I finally found that small application, it is called System scheduler, no user limitations and no stuff to hold back.

Now with that small app, you got to decide when it should run, and some other details, enough to make life easier

Anyways, here is the small "Autorun" Excel-macro if you think it will help you.