Pages

Search

Counting # Tasks Microsoft Project

Counting # Tasks Microsoft Project

Counting # Tasks

Posted: 21 Sep 2004 02:25 PM PDT

Oops. Forgot to paste it:

Sub countem()
SelectAll
MsgBox ActiveSelection.Tasks.Count
End Sub

-Jack


"Tom S" <microsoft.com> wrote in message
news:com... 
of 
function, 
the 

Access to MS Project files via IE without MS Project

Posted: 21 Sep 2004 03:33 AM PDT

Your post is a bit confusing because in one breath it seems you say you only
want a viewer which would allow users to see the files, i.e. read-only
viewing, then in the next breath you say you want them to be able to modify
the files. Which is it?

If you have multiple users, some of whom need to modify files and others who
just need to view them, and you want to do all this over an intranet or the
internet, how about using Project Server? People who need to create/modify
the project files would use Project Professional and publish the result to
the Server. Uses needing only to view the data, update their own hours,
etc, would use Project Web Access.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"Greg" <de> wrote in message
news:google.com... 

Redundant links in MSproject?

Posted: 20 Sep 2004 05:49 PM PDT

If what you mean by redundant links is a situation where for example you
have task A as a predecessor to Task C, and Task B as a predecessor to Task
C, and A as a predecessor to Task B, then no, there is not automatic way to
eliminate the dependency.

I think that with some clever programming you could do this. You would have
to create an array of the dependencies for a task, then trace each of them
and if a task which is in the dependency list was found one or more steps
removed from the task then you would eliminate that dependency. Of course
you would have to check for any lags as well, as there might be some valid
reason for the redundancy.

Since the presence of redundant links does nothing bad other than to clutter
the file I don't see much incentive to automate the elimination of them.

One macro which I wrote can help you to filter your project so that it will
be easier to find these things.
Look at the "Trace" macro at:
http://masamiki.com/project/macros.htm
and select "all" when you are using it.
It won't eliminate anything, but will filter out certain chains of events so
that it is easier to see them.

-Jack



"Phil Dieckmann" <microsoft.com> wrote in message
news:com... 

format Bar styles - resource units?

Posted: 20 Sep 2004 02:47 PM PDT

thanks thats all i needed, (ex. "Resource Name [xxx%]")

johnny

"Sean" <com> wrote in message
news:27c801c49f5d$4990ae50$gbl... 

Totaling durations across project files

Posted: 20 Sep 2004 02:45 PM PDT

How can one task have durations in more than one project?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"Betsy" <microsoft.com> schreef in bericht
news:com... 
I 
to 
clock 

1 Resource, 2 Tasks

Posted: 20 Sep 2004 10:53 AM PDT

David,
In MS Project, the resource leveling doesn't "contour" the work load of a
resource on a task (as some other software such as PMW did)
MS Project moves the entire task. So the resource may be under-allocated
during the 50% allocation of one of the tasks.

Gérard Ducouret

"David Mauceli" <microsoft.com> a écrit dans le
message de news:com... 
why 
tasks 

Set Start Time

Posted: 20 Sep 2004 10:27 AM PDT

Steve House thanks for your reply

Amortizing material costs

Posted: 20 Sep 2004 08:11 AM PDT

Project is a WORK management tool, not a financial management tool. It
doesn't amortize costs at all, it simply tells you when you acrue them.
How, when, or even if they get paid for is none of its concern. Frankly,
the rental cost of your fencing is not really a task cost - it is instead a
fixed cost associated with the entire project. If you get down to strict
definitions, it is not a material resource at all - the fencing is neither
consumed nor incorporated into the deliverable. Bricks and mortar, OTOH,
would be a material resource since they actually become part of the
deliverable. Properly speaking, the fencing is a facilties cost, same as
rents on office space, desks for your engineers, or the pickup trucks out at
the job site. Project considers those overhead. If you want to include it
in the costs being tracked by Project, you can add it together with any
other similar costs, display the Project Summary Task (Tools, Options, View,
Project Summary), display the Cost Table and enter those global project
level costs in the fixed cost field of the top level project summary task.
Since there are often more than one line item, I'd create a budget worksheet
in Excel where they are detailed, maintained, and summed, then use an OLE
link to drop them into the cost field in Project.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"Bill Vallance" <net> wrote in message
news:9qC3d.2148$news.prodigy.com... 

Custom columns & graphical indicators

Posted: 20 Sep 2004 06:54 AM PDT

Hi Renae,
Insert a Flag(x) field, then select this column and
Tolls / Customize / Fields
Formula : enter something like
IIf([Start]<[Status Date] And [% Complete]=0,0,-1)
Nb : This formula refers to the Status Date, you could use also the Current
Date field
Click the Graphical indicators button :
- Test for : equals
- Value : No
- Image : a red symbol ...

Gérard Ducouret

"renae" <upenn.edu> a écrit dans le message de
news:47dc01c49f19$52775e90$gbl... 

Word Wrap Title Columns

Posted: 20 Sep 2004 06:51 AM PDT

Hi Sandra,

Did you create this project ourself, with Project 2000, or do you use a
project created with 2002 version ?

Gérard Ducouret

<microsoft.com> a écrit dans le message de
news:319401c49ffa$8618d030$gbl...
Looks like I stumped everyone!

I'm using 2000 and the titles ARE wrapping. :-) I guess
we'll just call this an anomoly or "hidden feature".

Thanks for everyone's comments

Sandra

 
wrap titles using 
message 

Excel import

Posted: 20 Sep 2004 05:51 AM PDT

I'd recommend you flesh out a dummy project in Project with the basic
type of information that you expect to be importing from Excel, e.g.
Task Name, duration, work, work remaining, predecessors, assignments,
.... Then use the export/import wizard to export this data to an Excel
spreadsheet. Look at how it formats the data. Test this format and
your procedure by re-importing into a new Project file. Then, once you
get the hang of it and have it going properly, then populate the Excel
sheet with the data you really want to import and then just do it.

Hope this is useful to you. Let us know.

rms




Gérard Ducouret wrote: 

Defining Start Date of a Split Task

Posted: 20 Sep 2004 03:53 AM PDT

Hi John,

I'm afraid there is no other way to do that :-(

Gérard Ducouret

"John" <co.uk> a écrit dans le message de
news:google.com... 
news:<phx.gbl>... 
to 

Resource Availability and Resource Conflicts:

Posted: 18 Sep 2004 02:04 AM PDT

Hello Roy,
As Mike said, in the Resource Usage view, you have the work load (or
cost...) summarized resource by resource (Click the + sign in front he names
to collapse the details)
You could also use the Task Usage view which display the work rolled up on
each Summary .

Hope this helps,

Gérard Ducouret

"Roy" <microsoft.com> a écrit dans le message de
news:com... 
view 
a 
enough, 
seen at