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!

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!

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!

I suggest that you convince him to apply process, rather than look for
complex automated solutions. Get him to make his changes by a scheduled
time, have the server macro run x minutes afterwards, and a time he can look
at it. Whilst the computer can do anything if you throw enough resources at
it, but sometimes a simple process is a better solution.

Regards

Bob


"Steph" wrote in message
...
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!