|
View Full Version : Resource Leveling - Ignore a messagebox
I wish to create a macro that runs Resource Leveling.
In some cases (e.g. when resource is not available) I get a messagebox:
"Project cannot resolve the overallocation of "Name of resource" on 'date'. I
can Skip, Skip All or Stop.
How can I automaticaly Skip All?
Jan De Messemaeker 06-21-2007, 01:41 PM Hi,
Before the levelnow instruction put
displayalerts=false
Hope this helps
--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade
"Yoav" <Yoav@discussions.microsoft.com> wrote in message
news:D41845C8-951D-4FA6-BA2A-3E3488438C0D@microsoft.com...
>I wish to create a macro that runs Resource Leveling.
> In some cases (e.g. when resource is not available) I get a messagebox:
> "Project cannot resolve the overallocation of "Name of resource" on
> 'date'. I
> can Skip, Skip All or Stop.
> How can I automaticaly Skip All?
Hey, thanks!
Does it Skip, Skip All or Stop?
Ca I control the choise?
"Jan De Messemaeker" wrote:
> Hi,
>
> Before the levelnow instruction put
> displayalerts=false
>
> Hope this helps
>
> --
> Jan De Messemaeker
> Microsoft Project MVP
> http://users.online.be/prom-ade
> "Yoav" <Yoav@discussions.microsoft.com> wrote in message
> news:D41845C8-951D-4FA6-BA2A-3E3488438C0D@microsoft.com...
> >I wish to create a macro that runs Resource Leveling.
> > In some cases (e.g. when resource is not available) I get a messagebox:
> > "Project cannot resolve the overallocation of "Name of resource" on
> > 'date'. I
> > can Skip, Skip All or Stop.
> > How can I automaticaly Skip All?
>
>
>
Jan De Messemaeker 06-21-2007, 05:39 PM Hi,
It skips all.
If you want to control the choice you have to use an othe rmethod (keeping
display alerts true but use=ing the sendkeuys instruction - read all about
it in the help, not obvious!
Hope this helps,
--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade
"Yoav" <Yoav@discussions.microsoft.com> wrote in message
news:20537241-B677-4D63-94DE-83D4EA18A57F@microsoft.com...
> Hey, thanks!
> Does it Skip, Skip All or Stop?
> Ca I control the choise?
>
> "Jan De Messemaeker" wrote:
>
>> Hi,
>>
>> Before the levelnow instruction put
>> displayalerts=false
>>
>> Hope this helps
>>
>> --
>> Jan De Messemaeker
>> Microsoft Project MVP
>> http://users.online.be/prom-ade
>> "Yoav" <Yoav@discussions.microsoft.com> wrote in message
>> news:D41845C8-951D-4FA6-BA2A-3E3488438C0D@microsoft.com...
>> >I wish to create a macro that runs Resource Leveling.
>> > In some cases (e.g. when resource is not available) I get a messagebox:
>> > "Project cannot resolve the overallocation of "Name of resource" on
>> > 'date'. I
>> > can Skip, Skip All or Stop.
>> > How can I automaticaly Skip All?
>>
>>
>>
Thanks!
you are the best.
"Jan De Messemaeker" wrote:
> Hi,
>
> It skips all.
> If you want to control the choice you have to use an othe rmethod (keeping
> display alerts true but use=ing the sendkeuys instruction - read all about
> it in the help, not obvious!
> Hope this helps,
>
> --
> Jan De Messemaeker
> Microsoft Project MVP
> http://users.online.be/prom-ade
> "Yoav" <Yoav@discussions.microsoft.com> wrote in message
> news:20537241-B677-4D63-94DE-83D4EA18A57F@microsoft.com...
> > Hey, thanks!
> > Does it Skip, Skip All or Stop?
> > Ca I control the choise?
> >
> > "Jan De Messemaeker" wrote:
> >
> >> Hi,
> >>
> >> Before the levelnow instruction put
> >> displayalerts=false
> >>
> >> Hope this helps
> >>
> >> --
> >> Jan De Messemaeker
> >> Microsoft Project MVP
> >> http://users.online.be/prom-ade
> >> "Yoav" <Yoav@discussions.microsoft.com> wrote in message
> >> news:D41845C8-951D-4FA6-BA2A-3E3488438C0D@microsoft.com...
> >> >I wish to create a macro that runs Resource Leveling.
> >> > In some cases (e.g. when resource is not available) I get a messagebox:
> >> > "Project cannot resolve the overallocation of "Name of resource" on
> >> > 'date'. I
> >> > can Skip, Skip All or Stop.
> >> > How can I automaticaly Skip All?
> >>
> >>
> >>
>
>
>
Did you ever creae the marco and does it work?
--
"Yoav" wrote:
> Thanks!
> you are the best.
>
> "Jan De Messemaeker" wrote:
>
> > Hi,
> >
> > It skips all.
> > If you want to control the choice you have to use an othe rmethod (keeping
> > display alerts true but use=ing the sendkeuys instruction - read all about
> > it in the help, not obvious!
> > Hope this helps,
> >
> > --
> > Jan De Messemaeker
> > Microsoft Project MVP
> > http://users.online.be/prom-ade
> > "Yoav" <Yoav@discussions.microsoft.com> wrote in message
> > news:20537241-B677-4D63-94DE-83D4EA18A57F@microsoft.com...
> > > Hey, thanks!
> > > Does it Skip, Skip All or Stop?
> > > Ca I control the choise?
> > >
> > > "Jan De Messemaeker" wrote:
> > >
> > >> Hi,
> > >>
> > >> Before the levelnow instruction put
> > >> displayalerts=false
> > >>
> > >> Hope this helps
> > >>
> > >> --
> > >> Jan De Messemaeker
> > >> Microsoft Project MVP
> > >> http://users.online.be/prom-ade
> > >> "Yoav" <Yoav@discussions.microsoft.com> wrote in message
> > >> news:D41845C8-951D-4FA6-BA2A-3E3488438C0D@microsoft.com...
> > >> >I wish to create a macro that runs Resource Leveling.
> > >> > In some cases (e.g. when resource is not available) I get a messagebox:
> > >> > "Project cannot resolve the overallocation of "Name of resource" on
> > >> > 'date'. I
> > >> > can Skip, Skip All or Stop.
> > >> > How can I automaticaly Skip All?
> > >>
> > >>
> > >>
> >
> >
> >
Jan De Messemaeker 06-21-2007, 06:50 PM Who is this message addressed to?
If to me, I must have written over the past 10 years something like 15000
Lines of VBA code and it did work, why?
--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade
"Rob" <rob@rejcompany.com> wrote in message
news:63038F49-DD74-4DB8-AF85-6C5F1679E694@microsoft.com...
> Did you ever creae the marco and does it work?
> --
>
>
> "Yoav" wrote:
>
>> Thanks!
>> you are the best.
>>
>> "Jan De Messemaeker" wrote:
>>
>> > Hi,
>> >
>> > It skips all.
>> > If you want to control the choice you have to use an othe rmethod
>> > (keeping
>> > display alerts true but use=ing the sendkeuys instruction - read all
>> > about
>> > it in the help, not obvious!
>> > Hope this helps,
>> >
>> > --
>> > Jan De Messemaeker
>> > Microsoft Project MVP
>> > http://users.online.be/prom-ade
>> > "Yoav" <Yoav@discussions.microsoft.com> wrote in message
>> > news:20537241-B677-4D63-94DE-83D4EA18A57F@microsoft.com...
>> > > Hey, thanks!
>> > > Does it Skip, Skip All or Stop?
>> > > Ca I control the choise?
>> > >
>> > > "Jan De Messemaeker" wrote:
>> > >
>> > >> Hi,
>> > >>
>> > >> Before the levelnow instruction put
>> > >> displayalerts=false
>> > >>
>> > >> Hope this helps
>> > >>
>> > >> --
>> > >> Jan De Messemaeker
>> > >> Microsoft Project MVP
>> > >> http://users.online.be/prom-ade
>> > >> "Yoav" <Yoav@discussions.microsoft.com> wrote in message
>> > >> news:D41845C8-951D-4FA6-BA2A-3E3488438C0D@microsoft.com...
>> > >> >I wish to create a macro that runs Resource Leveling.
>> > >> > In some cases (e.g. when resource is not available) I get a
>> > >> > messagebox:
>> > >> > "Project cannot resolve the overallocation of "Name of resource"
>> > >> > on
>> > >> > 'date'. I
>> > >> > can Skip, Skip All or Stop.
>> > >> > How can I automaticaly Skip All?
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >
|
|
|