Turn Computer off with a Macro

Is the title of this thread possible to do?

I have a pretty complex system running that takes between 5-9 hours to run in Excel (all macro based). I was just wondering whether I could put a flag on one of the sheets that calls a macro to save the workbook and turn the computer off?

I leave simulations running while at work so it would be nice (to save electricity) if once the replay had finished the whole machine sorted itself out. Excel will be the only programme open when running a simulation. This is how I envision running it...

Please Login or Register  to view this content.

So, my question. Can I have a sub routine that gets called right at the end of my simulation to save the workbook and turn the whole machine off right from within VBA?

TIA.

Thank you very much for the link, it looks to be exactly what I am looking to do...

Please Login or Register  to view this content.

The above line works perfectly and logs off the machine but when I try and change the 4 to a 1 to shut down the computer (as apposed to simply logging the user out), the code does nothing. I click the button the macro is attached to and the system just sits there doing nothing. Any ideas please?