Pages

Search

Getting reports out of Project Microsoft Project

Getting reports out of Project Microsoft Project


Getting reports out of Project

Posted: 15 Feb 2006 05:51 PM PST


Hi John,
Thanks for the promt reply.
I am not manually entering the dates. I have a duration column in there as
well which I can estimate how long a particular task is going to take.
I am still having all sorts of trouble getting the reports out.
Basically my 10 main tasks are nav charts. The sub tasks under these
individual charts are the processes needed to make and provide Quality
assurance to these charts. Most of these sub tasks are linked ie one cant
start to the other finishes.
I have the task name with sub tasks, duration(days), start, finish and
resource names(employees). these charts run for approx the next 4 months.
What i need is to be able to report when the resource names next become free
so i can allocate them to the next available task.

"John" wrote:
 

how to make a macro run other macros

Posted: 15 Feb 2006 01:07 PM PST

Thanks, Jack. After all that, all I needed the macro to look like was
this:

Sub Pubs_Test2()
'
' Pubs_Test2 Macro
' Macro copied from Excel 2/15/2006 by Me
'

'
Pubs_one
Pubs_two
Pubs_three
Pubs_four
End Sub

And it works like a charm!

Great! Thanks.

No task to finish on the weekend?

Posted: 15 Feb 2006 12:11 PM PST


Hi,

I understand your dilema well.

Set up a second calendar which has Saturday and Sunday as non working. Call
it 5 day calendar (orignal eh). Then assign that calendar to the relevant
tasks. Now you can have a project which can work seven days per week where
appropriate, but only five days for 'office' type functions. You could also
set up the resources with the five day calendar as well and leave the tasks
on a seven day calendar and that would give the same result.

Hope this is of some help

Regards
DavidC

"uttster" wrote:
 

Linking tasks not in the same project

Posted: 15 Feb 2006 11:37 AM PST

Yes you can.

(a) Let's say you have "Project One.mpp" and "Project Two.mpp"

(b) Let's say you want Project One Task 5 as a predecessor
to Project Two Task 7

(c) Open both projects up in MS Project (any version)

(d) Double-click on Task 7 in Project Two

(e) Click on the "Predecessors" Tab

(f) In the ID column, type in: Project One\5

(g) Hit return.

(h) The task is now connected.


--
Rick Roszko
PM, MSPS, Network Consultant


"Kim" wrote:
 

VBA Macro for MSPP 2003

Posted: 15 Feb 2006 11:31 AM PST

In article <com>,
Mike B <microsoft.com> wrote:
 

Mike,
You're welcome.

John 

Neck Bars for Non-Work days?

Posted: 15 Feb 2006 07:39 AM PST

Thanks John, I would like to use P3 but our company doesn't have but a few
people who know anything at all about P3. It is going to be a feat to get
them up to speed on MS Projects. Oh well, I'll work through it.

Thanks again,

COZWV



"John" wrote:
 

Printing Issue

Posted: 15 Feb 2006 07:09 AM PST

Hi Ray,

Welcome to this Microsoft Project newsgroup :)

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #8 on Printing, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the article before leaving the site, :)
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on :)

Mike Glen
MS Project MVP

raydeo wrote: 



importing documents into project

Posted: 15 Feb 2006 06:32 AM PST

Thanks so much Julian.

Your post prompted me to try changing the registered file type in XP to
point to Adobe Acrobat 5.0 (not reader). Sadly, still no joy.

Thanks for your diligence. If you do come across another piece of
information, please do post to the newsgroup. I know this has been a
question off and on by several folks for awhile.

Julie
"Prj_Mngr" <microsoft.com> wrote in message
news:com... 


Changing Predecessor not updating start date

Posted: 14 Feb 2006 06:10 PM PST

Thanks a lot Jack. Learned from this one too.

"JackD" wrote:
 

Interim Plan Finish Variance

Posted: 14 Feb 2006 01:57 PM PST

that works - you're a lifesaver!


"Rod Gill" wrote:
 

Modifying Project 2003 to access a Resource Pool on a Web Server

Posted: 14 Feb 2006 12:33 PM PST

Mike, thanks for the answer. I am using MS Project 2003 Pro SP1. I posted
in the Server group as well.

"Mike Glen" wrote:
 

Covert local userdefined fields to Enteprise ones

Posted: 14 Feb 2006 11:04 AM PST

In article <com>,
"Hadi" <microsoft.com> wrote:
 

Hadi,
If the user defined fields are task based the following code should
work. Note, you will need to have a separate line of code for each field
you want to transpose.

Sub Transpose_Fields()
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
t.EnterpriseText1 = t.Text1
t.EnterpriseOutlineCode1 = t.OutlineCode1
End If
Next t
End Sub

John
Project MVP 

Team Foundation Server /Project Integration Issues - Hey Dale/Gary

Posted: 14 Feb 2006 09:59 AM PST

Rod and others:

The more I read and experiment with VSTS/TSF the more I realize how poorly
these products are integrated. For example, TSF does not store task
dependencies (sucessors or predecessors).

Also, data is not LINKED to Project Server, rather COPIED to a .MPP file
WHEN YOU REQUEST it to be COPIED. And yes, I mean COPIED and not LINKED.


"Rod Gill" wrote:
 

Access to MSProj

Posted: 14 Feb 2006 07:15 AM PST

Hi Jan,
Could you please elaborate on this. I am fairly new to Project and a novice
in Access. I want to export time card information from access time-card to
project tasks (information like hours, dates and Phy % Complete). Please
direct me how to go about this. Do we need to install macros or chage VBA
codes?
Thanks
Ranjana
--
Master''''s in Industrial Engineering
State University of New York at Buffalo


"Jan De Messemaeker" wrote: