Exporting Time-phased data
Hi,
In the Task Usage view, the right pane shows cost, work, % complete,
etc. but the only way I've found to 'export' this data is by copying and
pasting the two panes (the left pane with the task rows, and the right
pane with the time-phased data) into Excel.
Is there a way to auto-magically export it all at once into a text file
(.csv or .txt)?
~ Don Tag: VBA for Project Tag: 87239
VBA for Project
Hi,
I am trying to customize my database using 2-4 filters at the same time.
However, when I run it, the Filters Over-ride each other and give me the
incorrect result.
Is there anyway to go about solving this problem?
I have read a book on VBA but it doesnt help. Is there a way of using VBA to
solve it?
Any Help would be Appreciated.
Thanks Tag: VBA for Project Tag: 87233
Cost factors of material resources
hi,
i got a situation. i have a pool of material resources. these materials have
some standard cost on each unit being used. so i defined per use cost for
each for them. but for some task if i use 2 units of that material resource,
then the per use cost is accounted for only one unit.
is there a way by which i can calculate the peruse cost for each unit of
material resource being used?? someone pl help me out..
thnx & regards
Eswar Tag: VBA for Project Tag: 87231
Ignoring Resource Calenders While Scheduling
hi,
i have saved some test projects on to my test server and there are many
common resources in those projects. wht i noticed is that the scheduling gets
adjusted automatically based on the resource availability. so i removed this
by checking "Scheduling ignores resource calanders", under Advance tab in
Task Information Dialouge box. wht i want to know is:
- are there any disadvantages of using this kind of scheduling?
regards
Eswar Tag: VBA for Project Tag: 87223
MSP98 and 2000 compatible?
I use MSP2000 at work and have to bring home the laptop every night. Big
pain!
I also found my old MSP98 CD, and still have the product key, license, etc.
Q: can I save my schedules at work in the 98 version to be viewed at home?
I don't want to install it unless this will work.
thanks Tag: VBA for Project Tag: 87169
Enterprise Resources HELP!
I recently imported a select number of resources from a project into the
enterprise resource pool. This action made the balance of my resource
non-viewable as enterprise resources - even when startin a new blank project
I could not see my users using Build team from server. To UNDO the situation
I used the Clean Up Project server.. and deleted the imported resources.
This did not solve the problem. I still see no resources from PWS when I
attempt to build team from PS.
I wonder if this has anything to do with the fact I have a default set to
administrator for Project server when I launch Project Office 2003. Does this
affect the view to the enterprise? I don't see how but thought I would ask.
Note: I am a user in PWS with administrator rights. I needed to set the
project server accounts to Administrator in order to edit the global template.
All I really want to do is get back to the state I was in prior to the
Import of enterprise resources. There are only 15 users in PWS and it is not
currently in use. What do you suggest I do? Tag: VBA for Project Tag: 87122
Can I use project to track public event?
Hi, I am wondering if I could user project 2003 to track public events. I
guess I could enter each event as a task, and the internal contact as
resource. But is there anyway I could enter the external attendees to each
event?
I am new to project, any help is much appreciated!
--
-- Wei Tag: VBA for Project Tag: 87116
Why is BCWP zero?
I am just learning to manage costs using Project. I have baselined my project
but my BCWP is still at $0.00 for all tasks. Naturally, that makes my CV
equal to my ACWP. Any ideas to help?
--
Jay R Tag: VBA for Project Tag: 87112
vba datedifference type mismatch?
hey!
I want to use the datedifference function.
and i want to use the "task calendar" as the calendar parmeter.
something like this:
-------------------------------------------------
dim activity as task
For Each activity In ActiveProject.Tasks
msgbox(application.datedifference("10.07.05","12.07.05",activity.Calendar)
next
---------------------------------------------------
but this result in a type mismatch error!!!! :(
("10.07.05","12.07.05",activeproject.Calendar) works fine.
got a clue why?
pls hlp
-Bjorn , Norway Tag: VBA for Project Tag: 87104
Installation question about location of Analysis Services/DSO
Ok, I'm currently working on a project to install Project Server 2003 leaning
more to a medium scale roadmap. I have only preformed small scale installs
in the past having all services web and database on one server.
Currently I have SQL 2000 Analysis Services/DSO, Project Server Front-End
Service, and View Processing Services (everything but the sql ps database and
sharepoint database) on one server. ServerX
On ServerY I have SQL 2000 Server installed with Project Server database,
SharePoint Content, and SharePoint Configuration databses installed.
I'm now at chapter 8 Post installation task Page 130 in the Microsoft Office
Project Server 2003 installation Guide. Section Migrate the Analysis
Services Repository to a SQL Server Database.
Question: I need to migrate the repository from ServerX where Analysis
Services/DBO is installed to ServerY where SQL 2000 Databse is installed.
There is no Analysis Services on ServerY with NO OLAP administrators group.
The only OLAP group is on ServerX where all of the IIS services are
installed. But the OLAP admin groups needs to be DB_OWNER for the repository.
So, do I need to install all SQL Server services Analysis Services, DSO, and
databases on ServerY to make this work? Am, I asking a question I already
know the answer for?
--
Hewitt Gordon
Network/Desktop Analyst I
HNTB Corporation
715 Kirk Dr.
Kansas City, MO 64105 Tag: VBA for Project Tag: 87101
MS Project 2003
I have just installed Project 2003 and am having a lot of problems. Initially
these related to the program looking for GBUI://mainpage.htm/ but I managed
to fix this using technical support. Now the program opens but the default
entry screen is totally missing - the screen is totally blank. I have tried
everything to resote - even if I load an existing Project - it appears to
open but is completely blank.
Help!
Thanks Tag: VBA for Project Tag: 87098
Copying Environments to other users
I am attempting to prepare our Department to use MS Project. I need an
environment with everyone having access to several custom macros, tables and
views as well as starting with the same Option settings. I copied the
Global.mpt with all those objects and settings to a common network folder.
To test it, I copied that Global.mpt to another person's PC (we have MS
Project installed on each person's PC - no Enterprise version). When I
opened project on their machine, it indeed showed the macros, tables and
views as desired, but NONE of the option settings came through. Are these
not kept on Global? Is there a way, outside of having each person set their
own options using instructions I would supply, to set these options
automatically? Tag: VBA for Project Tag: 87093
Removing tasks from a timesheet
Hi, does someone know a solution to the following problem:
When tasks have been assigned to users within Microsoft Project, once a user
has completed the task and is no longer going to be doing anymore work on the
task, can this task be removed from the users timesheet.
Thanks,
Hema. Tag: VBA for Project Tag: 87092
filter blank lines in gantt chart
hi,
I have a gant chartt with some empty task lines in it, this helps
readability IMHO.
Now when I run a filter to print only certain tasks is there a way to keep
blank lines included?
I don't want to add something in the blank line as this messes up the other
fields for that task.
thanks Tag: VBA for Project Tag: 87090
Viewer for Project?
My contractor uses MS Project and he wants to send me his draft
schedule. How can I view the schedule he has created? Is there a Viwer
that5 I can download? Or, can he export the Project schedule to an
alternative program such as Excel?
Bill Starbuck (MVP) Tag: VBA for Project Tag: 87089
Need help using xlt. file
I d/l a template from Microsoft office and when it asked me to save it, I
saved it under my docs./my received files. I saved as : 01018311 XLT.file
Now I can't open it. I don't have excel, but it said I could extract it.
How?? Please can someone help? Thanks! Tag: VBA for Project Tag: 87088
Comparison to Niku Workbench
I am looking for the opinions of those who have experience with Niku
Workbench (which is a project management software program similar to MS
Project).
How does Workbench compare to Project?
Is there a big learning curve? Seems like there would be.
How is the support?
Can anyone suggest readings to compare the two products? I have not seen a
single book on Workbench.
Any viewpoints on the two products would be most appreciated.
Thanks.
- - - jzis Tag: VBA for Project Tag: 87087
Remove a task from the critical path
How can you remove a task from the critical path? I have a hammock task that
moves with the end date, but its not critical. It moves with the end date
because its a support task that needs to keep going as long as the project is
going. However, because it extends to the end of the project, MSProject is
marking it as a critical task.
Any ideas? Tag: VBA for Project Tag: 87078
Showing Resource allocations on one page
Opening resource allocations indicates 200% useage for one person on one
day, so okay, I goofed something, but the print version is about 30 pages!
[almost a year] Yes, I can print just that one page, but is there an option
that compresses resources to one graph? Or chart? Not pages of bars? Tag: VBA for Project Tag: 87077
Material Resource overload
Hi, I have a question on overloading materials in MS project 2003. when you
create work resources you can set max units so it will show you the
overallocation of your resource. However, it is not possilbe to do that with
material resources. lets say I create a material resource and want to set a
max unit to use during the project so MS project can tell me that I exceeded
that amount. is that possible.
help is appreciated Tag: VBA for Project Tag: 87065
Scheduling with a deadline while behind schedule
Here is my problem: I'm currently scheduling so that production ends on the
deadline however we are behind schedule. When I update the schedule to move
all of the late tasks to the current date it just piles them up on that date
with no regard for predecessors. I realize the problem is that I'm
scheduling with conflicting constraints but is there some way to resolve
this? I would like to spread everything throughout the time window and maybe
adjust the max units of my resources to account for overallocations. Thanks
for your help.
Josh Tag: VBA for Project Tag: 87064
Managing Consultants
I'd like to set up consulting assignments as tasks in my project. I'd like
to be able to record invoice amounts against the contract value. This does
not need to take the place of the % completion calculation, but rather,
provide a method to summarize the actual costs to date.
Example:
Hire an architect to design a building. The contract is for $30,000. At
the end of the first month, I recieve an invoice for $7453.22. The second
month I recieve an invoice for $6781.58. How can I show this in MS Project? Tag: VBA for Project Tag: 87063
Excel VBA to create and populate a MS Project file
What i have now is a Project file with "links" that whenever a change is made
to the outlook file, it's reflected in the Project file, but it's not working
out exactly how we'd like it to. I am unable to remove the links using a
macro/VBA in excel (Where all of the operations are running from) so the file
always asks if one would like to update the linked information whenever
changes happen in the Excel file, which is not what we want. Once exported,
the Project file should become static. A Project file that has all of the
information that was displayed in the above table at the time of running the
macro, but will not change or ask to be updated.
Of course there probably are other ways to do this better, like Projects
mapping feature to open an exported XLS file or possibly just simple
copy/pasting within the macro, but i can't for the life of me figure my way
around the syntax and funtionality of controlling Project from Excel.
I'm going to try and summerise just to be clear.
1) Data in excel populates the a table with info for the tasks, start/end
dates and resources of a specific project.
2) A button labelled "Export to MS Project" is clicked in the Excel file.
3) A series of VBA steps end with a MS Project file saved and closed which
contains all of the Task Names (5 to 10 of them), Start and end dates, and
resources from the excel file. Tag: VBA for Project Tag: 87059
Slip task
I understand how to split a task, but here is my problem:
Task Start date of 4/11/05 - Finish date of 5/24/05 (20 days duration)
There was a interrupt to ONLY this task that delayed the task from
starting/finishing on time, the delay started on 4/11/05 resume work on
4/28/05 (duration 13 days).
Instead of an interrupt to the calendar (cause this will effect all of my
task) I split the task - I can't get the split to start on that day, it wants
to start on the 4/12.
My question is:
Is there any way of adding columns for split task that shows "Stop Work"
(date), "Resume Work" (date), and "Duration of Interrupt" (days? And yet
still be able to show on the Grant Chart as a split to the task on the bars? Tag: VBA for Project Tag: 87055
Outlook Integration Wizard / Addin for Project 2003
I use Project 2003 Pro - standalone, with no server tiein. I would love to
have the tasks synched up with outlook tasks. I have been hunting for the
addin but I cannot find it. Is it a component of the server? or can I use it
without the server component. The local help says to go to MS Project Web
Access, but I cannot find this url; I'm thinking that this too is a part of
the project server. I look forward to your feedback.
Thanks again,
Rick
PS - Yes, Toby did eat my shoe :) Tag: VBA for Project Tag: 87054
How to change pjDate_Www_dd ?
A question that many people has asked in MP forums is not yet responded.
When we choose the date format w5/1, MP shows dates in this new format, but
the problem is that the week showed might not be the one we need. For
example, as of this week, MP shows W29/4 for today, and what I understand,
and also I need, is to show W30/4 (for the same date, July 21, 2005)
Is there a way to create a macro to change how MP displays that date when
the date format W5/1 (pjDate_Www_dd) is choosen ?
Something like :
new_ww = ww +1
pjDate_Www_dd = pjDate + _'W_' + new_ww + '_dd'
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=7d39f38c-10fa-4f83-9de5-5aff774abcdb&dg=microsoft.public.project Tag: VBA for Project Tag: 87053
Can null value cells be shown as blank.
Much of the project plan I am building has cells with null values. So I'm
seeing pages of "N/A"s or 0's. I'd love to reset the default for an empty
cell to show nothing a so make the project as a whole far more readable. Is
there a way to do this?
Thx Tag: VBA for Project Tag: 87044
Can I network 2 computers 1 with ME and one with XP?
I am trying to set up a network where 2 computers have ME and one has XP. I
can recoginze and access the ME system from the XP, but not visa versa. Tag: VBA for Project Tag: 87043
Resource usage and graph
I have a project which has the working time calendar set to 6 hours of
productive labor a day. That leaves 2 hours for meetings, and other not
project related activities.
For one resource the "Resource Usage" for a given day shows 6 hours, in
red, and the "Resource Graph" shows 200%. I don't get it.
I can see how there may be a calculation rounding issue and it would
allocate e.g., 101%, but not 200% unless it assumes that resources only
come in integral increments.
Am I missing something here?
Thanks.
Thomas
--
Three stages of truth for scientists:
(1) It's not true.
(2) If it is true, it's not very important.
(3) We knew it all along.
Leo Szilard, (1898-1964, Key figure in the Manhattan Project) Tag: VBA for Project Tag: 87039
Resourcing will not feed through to pool
On numerous occasions we have resourced plan with resources from the pool and
the following occurs;
-within the entry view the name of the assigned resource appears in the
resource name column
-the name appears adjacent to the activity in the Gantt chart
Both outcomes expected, however,
-within the Resource Usage view there are no work hours defined for that
resource.
-the EAC field does not recognise the resource cost as it believes it is not
assigned.
We have found a temporary work around which resolves the issue. We have to
take the resource units down to 0% apply the change then reset it to the
desired units of 100%. There is no consistency in this error as it has
occurred on different plans at different times with different resources. Can
anyone help me resolve this glitch as it is incredibly inefficient to have to
keep checking every resource to ensure the work hours have been recognised?
Kind Regards. Tag: VBA for Project Tag: 87031
connect failed to project server from project profession
I've installed project server 2003, sql server 2000 on a server running
windows server 2003, now I want to link from a client in the same domain on
which project profession installed to the project server, unexpectedly,the
failuer information prompt:
Connection Failed:
SQLState: 01000
SQL Server Error 1326
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(CreateFile())
Connection Failed:
SQLState 08001
SQL Server Error: 1326
[Microsoft][ODBC SQL Server Driver] Client unable to establish connection
Anyone can tell me why and how to solve this problem?
Thanks indeed. Tag: VBA for Project Tag: 87026
How do I Group by Early Finish and not show the date range in hea
I have grouped my project by Early Finish, with the interval being months.
The Heading of the group is Early Finish ddd dd/mm/yy - ddd dd/mm/yy
where is shows the start and finish date of the month of the group.
I would rather it just said the month ie mm/yy
is this possible Tag: VBA for Project Tag: 87025
Formatting - date, cost, decimal places
Office 2000 SP1 using Task Sheet view
How do I change the format of Cost to remove the 2 decimal places?
How do I Change the date format from DDD_DD/MM/YY to DDD_DD_MMM?
How do I change the format of the duration field to only display whole
units, not decimal places? Tag: VBA for Project Tag: 87020
Resourse Unit Entry
Scenario: A single task with multiple part-time resources.
Example: A 5-day task with Resourse-1 needed for 4 hours, Resource-2 needed
for 8 hours, and Resource-3 needed for 24 hours.
Problem: Duration is set to 5-days. I want to the work and hours columns
to calculate automatically. I want to enter the resourse time in hours units
(not %) directly in the "Resourse Name" field. For example, the field could
be entered as follows: Resourse-1[4h], Resourse-2[8h], Resource-3[24h].
Question: Can this be done in project in either a Gantt or other view that
has individual tasks associated with it? If yes, great! Please tell me how.
If now, then is there a third party solution that enhances resourcing
projects to meet my objectives?
Thanks in advance for your help,
Bruce Tag: VBA for Project Tag: 87019
importing from excel
When I try to import from excel, I keep getting an error message stating a
worksheet name must be selected even though the file name appears in the
import from box and the preview pane shows the correct information. Project
will not allow me to Finish the import. Has anyone else experienced this
problem? More importantly, does anyone know what I can do to fix it? Tag: VBA for Project Tag: 87013
Summary task time
The summary task is not showing the sum of time for all subtasks, but only
the first one? How can I fix this? Tag: VBA for Project Tag: 87012
Summary task not progress Properly
I recently notice the summary task were not progress Properly. Some task
went beyond the status date and some not even progress. Wheres the problem?
I want my schedule to show all the summary tasks are progress up to status
date. Tag: VBA for Project Tag: 87002
Create Project by Person
What might be a good way to go about creating a project by person? So,
instead of creating a project with tasks and assigning people to those
tasks, I'd like to create a project that first lists people, and then list
tasks per person.
Thanks,
Jim Tag: VBA for Project Tag: 87000
Sending info to client without including cost data
I am currently working on a project as a subcontractor. I need to send my MS
Project file to the prime contractor but do not want to send my resource cost
data? I have to send the whole file because the prime needs to integrate my
schedule with their master schedule. Their purpose is for overall tracking
of the schedule, not cost.
Any suggestions on how to effectively forward the schedule but remove the
cost data? My first thought was to password protect the resource sheet;
however, that doesn't seem to be an option.
Thanks,
Cindy Tag: VBA for Project Tag: 86997
how to print tasks limited by timescale
I think I found the answer to this (or even posted this same question) but
lost it. So, if you guys don't mind. Here is the question again.
In File|Print there is an option to set a time range to print. This limits
the timescale, but it doesn't affect the tasks that are printed. Is it
possible to make Project print only the range of tasks that are affected by
the date range? When I used a filter to exclude the other tasks, it resulted
in a bunch of summary task bars. Maybe I'm on th eright track... i'll try
hiding those bars. Still, there must be an easier way.
Thanks in advance,
Tom Tag: VBA for Project Tag: 86995
Thanks, all you guys for your comments they really helped.
Everything is working just the way i want it to