View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_3_] Steph[_3_] is offline
external usenet poster
 
Posts: 312
Default Execute code on server

Hello. I have a seemingly simple scenario, but not so sure the solution is
simple! Here it is:

A member of Sr Management executes a macro every so often (long story as to
why HE has to do it...just accept the fact that he does). Right now, the
code resides in the workbook that he opens and pushes a button. This code
does lots of stuff (opens other workbooks, etc) and takes a while to run.
And obviously, this is running on his machine.

Here is the scenario I would like:

He opens a "front-end" file that has a button. This button executes the
code on a server, NOT his machine. So he pushes the button, and then
immediately can close his workbook. Meanwhile, the code is running on a
server and not his machine.

Possible? Thank you!