LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do you execute single line of code? honestlylion Excel Discussion (Misc queries) 2 February 24th 06 03:35 PM
Why does this code take so long to execute. John Keith[_2_] Excel Programming 4 March 6th 05 07:44 PM
When does Code Execute on a List Box? John Baker Excel Programming 0 January 11th 05 08:24 PM
Execute a query against an excel doc and a sql server db Rick[_14_] Excel Programming 1 August 30th 03 02:50 PM
execute code for all 12 months Herb Buist Excel Programming 0 July 19th 03 03:43 PM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"