$$Excel-Macros$$ Re: Running Macros when Multiple Excels are open

2010-06-03 Thread donvreug
Thanks for yor help Stuart. Regards Don On Jun 2, 2:27 pm, Stuart Redmann wrote: > On 1 Jun., 01:57, donvreug wrote: > > > The environment this is occuring in is a corporate one where there are > > a number of Excel workbooks each with VBA modules that are deisgned > > for different tasks.  Oc

$$Excel-Macros$$ Re: Running Macros when Multiple Excels are open

2010-06-02 Thread Stuart Redmann
On 1 Jun., 01:57, donvreug wrote: > The environment this is occuring in is a corporate one where there are > a number of Excel workbooks each with VBA modules that are deisgned > for different tasks.  Occassionally someone tells me a macro has > failed, and when I check they usually have two or

$$Excel-Macros$$ Re: Running Macros when Multiple Excels are open

2010-05-31 Thread donvreug
The environment this is occuring in is a corporate one where there are a number of Excel workbooks each with VBA modules that are deisgned for different tasks. Occassionally someone tells me a macro has failed, and when I check they usually have two or more Excel workbooks open. Closing all workb

$$Excel-Macros$$ Re: Running Macros when Multiple Excels are open

2010-05-31 Thread Stuart Redmann
On 30 Mai, 02:26, donvreug wrote: > Some of the macros I have written sometimes do not function correctly > if another instance of Excel is open. The other instance usually also > contains macros that may or may not have been executed.  I thought I > read somewhere that this is a common problem bu