Running Macro - Remotely

[betty02]

Just a quick one to see if it's possible then I can maybe add more detail.

We have a button on a spreadsheet that runs a macro of stopping a service then another button that starts a service. Every so often someone needs to load up Remote Desktop, login an then they press the stop process button, wait 5 seconds and then hit the start process button.

Is it possible to have a button locally that can do this connection and call the stopping of the process? Or a script that can run where I can enter in the IP and username/pass for the remote machine or something like that?

Or simple terms am I asking for too much?

 

[Jeffrey Mahoney]

Let me get a few details. You have a macro running continuously? You want to stop that macro and restart that macro once or more a day?

If yes for both of those, can the macro be restarted at the same times each day? If so, then code be added to check the time, stop running, and use the Application.OnTime function to call a SUB in a few seconds to restart the macro.