Re: Resources In alphabetical Order

From: Rod Gill (rodsngtrap_at_hotmail.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 16:46:25 +1200

Hi,

Simplest is to do a Name sort in Project first. If you select the renumber
option the ids renumber so resource names are alphabetic.

You can do the name sort manually or in VBA. 

-- 
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/
"Esperanza" <esperanza.meza@aps.com> wrote in message
news:e682f001.0406281358.515f6f44@posting.google.com...
> Hello, I had a question about getting  a macro that I built in Project
> to be able to alphabatize Resources.  This is some of my code:
>
> For Each R In Proj.Resources
>     xlR.Range("B1") = R.Name
>         For Each A In R.Assignments
>         'filter assignments that are not complete and scheduled to
> start within the next two weeks
> .........
>
> Currently this macro opens an excel time*** and puts the data in a
> spread***.  The main point is that what i have now gives me these
> resources sorted by ID, how do I get this to sort it by name in Excel?
> Thanks.
Quantcast