Hi Bob. Thought about that, but the scheduled aspect won't work. He makes
changes to a file, and then executes the code. There is no set time or day
that this is done.
I was thinking maybe a
VB script? So his button opens a
VB script - and the
script opens the file and runs the code within that file on the server?
"Bob Phillips" wrote in message
...
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!