Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Interaction on Server
We have several production reports that, after the main data extractions, are
processed and formatted using Excel VBA macros. These all run on our production server. I have noticed that if something goes wrong with one of them, (say it errs out) then others that come later tend to fail. So, I don't know if I'm phrasing this right, but is there something proactive we should be doing to ensure that an Excel macro won't conflict with another one? Also, as there's a lot of cut and paste in these things, if two jobs wind up running at the same time, do they each keep track of what they have on the clipboard, or is there a risk for cross-contamination? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro interaction | Excel Discussion (Misc queries) | |||
macro/worksheet/chart interaction | Excel Discussion (Misc queries) | |||
macro/workseet/graph interaction | Excel Programming | |||
How can I stop a macro for Human Interaction | Excel Programming | |||
Run Excel Report on Server w/out human interaction | Excel Programming |