Execute code on server
How about running a scheduled job on the server that does the work, and
creates an output file that his macro just loads?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Steph" wrote in message
...
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!
|