will they crash if two programs run at the same time? how to avoid if yes?

What two programs? What is it you want to do? Do you mean two versions of
Excel? HTH Otto
"Angus" <(E-Mail Removed)> wrote in message
news:2DEF07FA-328B-4DA7-8B9F-(E-Mail Removed)...
> will they crash if two programs run at the same time? how to avoid if yes?

Windows has multitasking capability. Whether you can run VBA macros
simultaneously would depend a lot on how they are constructed and whether you
are using the same instance of Excel to do it. I would suggest browsing the
web for some background on multi-tasking and multi-threading before trying it.

"Angus" wrote:

> will they crash if two programs run at the same time? how to avoid if yes?

Hi Angus,

whether same time is possible at all is debatable.
Usually, one after the other.

The programs get time slices,
a part of time for program 1,
a part of time for program 2.

If you got two different machines, then it is ok.

But imagine two programs from two different machines
writing data at the same time to a mass storage.
Which will win?

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Say, i have a vba excel program runs every 3pm. It will take about 15 minutes
to run.

If I run another vba excel at 2:55pm and it will take 25 minutes to run, and
the above program runs at 3pm, what happen?



"Helmut Weber" wrote:

> Hi Angus,
>
> whether same time is possible at all is debatable.
> Usually, one after the other.
>
> The programs get time slices,
> a part of time for program 1,
> a part of time for program 2.
>
> If you got two different machines, then it is ok.
>
> But imagine two programs from two different machines
> writing data at the same time to a mass storage.
> Which will win?
>
> --
> Greetings from Bavaria, Germany
>
> Helmut Weber, MVP WordVBA
>
> Win XP, Office 2003
> "red.sys" & Chr$(64) & "t-online.de"
>
>
>

Angus,
Depends how these 2 jobs are scheduled and whether they are connected in
some way, either in code or in the same instance of Excel.

If you are using Application.OnTime, read the help, as it says the first
argument is "Earliest time".
However, without more details of what you doing and how, the answer is "Yes,
No, Maybe".

NickHK

"Angus" <(E-Mail Removed)> wrote in message
news:77CDBEEC-30A9-4496-BEC8-(E-Mail Removed)...
> Say, i have a vba excel program runs every 3pm. It will take about 15
minutes
> to run.
>
> If I run another vba excel at 2:55pm and it will take 25 minutes to run,
and
> the above program runs at 3pm, what happen?
>
>
>
> "Helmut Weber" wrote:
>
> > Hi Angus,
> >
> > whether same time is possible at all is debatable.
> > Usually, one after the other.
> >
> > The programs get time slices,
> > a part of time for program 1,
> > a part of time for program 2.
> >
> > If you got two different machines, then it is ok.
> >
> > But imagine two programs from two different machines
> > writing data at the same time to a mass storage.
> > Which will win?
> >
> > --
> > Greetings from Bavaria, Germany
> >
> > Helmut Weber, MVP WordVBA
> >
> > Win XP, Office 2003
> > "red.sys" & Chr$(64) & "t-online.de"
> >
> >
> >