Pages

Search

Turn off Export Map Wizard Microsoft Project

Turn off Export Map Wizard Microsoft Project

Turn off Export Map Wizard

Posted: 20 Jan 2005 02:07 PM PST

Hello MEd,
Quite simple : that's a VBA macro that you can record. Just add the
Application.Alerts False method

Gérard Ducouret

Example :
Sub Mapping()

' Macro Recorded 21/01/05 00:22 by Gérard Ducouret.
Application.Alerts False
FileSaveAs Name:="C:\Documents and Settings\PragmaAdm\Mes
documents\PragmaSoft.xls", FormatID:="MSProject.XLS5", map:="Top Level Tasks
list"
End Sub


"MED" <microsoft.com> a écrit dans le message de
news:com... 
them 
I 

how to add a billing rate which is different from the cost rate?

Posted: 20 Jan 2005 12:53 PM PST

Tks Julie, it worked.... partially:

Before, I did not divide [Work] by 60. Now it works, although I don't
understand why I should do that since [Work] is already set as hours in my
project.

My problem now, is that I cannot have the billing rate at the resource level
and the billing budget at the task level + details at the resource level:

If billing budget is a Task type custom field, I cannot use the billing rate
in my formula if it is set as a Resource type custom field.
If Billing budget and billing rate are both resource types, I cannot see the
task details of my billing budget. In fact, I can only see the total billing
budget of my resource in the Resource sheet.
If Billing budget and billing rate are both task types, I cannot see the
resource details of my billing budget.
What I really want is to reproduce the Cost scheme, but for billing.

Do you have a solution for this?

Juliem
*****

"JulieS" wrote:
 

update task by email

Posted: 20 Jan 2005 12:19 PM PST

Dear JulieS
Thank you for your information, i did it the way that shows the article.

Now i believe that I have a bug or something, here is my test that I did so
far:
"as a test I created a test project file with three task.
(one day = 8 hous of work)
task 1 -- 1 day -- start today
task 2 -- 1 day -- start tomorrow
task 3 -- 1 day -- start the day after tomorrow.

Now, I assign me for those three task. I send, ONLY for the task 1, a
"Request progress information..", i recieved the email myself, i type 8 hours
of work to simulate that the work was complete today, I sent the update.
Later i recevied the update and I update the project file.

Now, when I click update project (from the email), my project file is open,
BUT here is the problem, this automatization add ONE more day to the task 1,
and mark 50% complete, when I supposed to mark 8 hours or 100% complete.
This increment all other task since are linked.

this is a bug, or not.

Also, i would like to send by email, the % completed of the task, and NOT
the HOURS of some day. Where i can modify that????

By the way, I installed Project Prof. 2003 instead standar 2003.

Thanks,



"JulieS" wrote:
 

Custom Text Fields and Formulas

Posted: 20 Jan 2005 10:13 AM PST

Hi Jack,

Brilliant! So much more elegant than my solution. ;-)

Julie

"JackD" wrote:
 

How do I change default duration from days to hours

Posted: 20 Jan 2005 07:55 AM PST

Hello Ray :
Tools / Options / Schedule / Duration is entered in... Hours
Set as Default

Gérard Ducouret


"Ray Stevens" <com> a écrit dans le message de
news:eoeExhw$phx.gbl... 
hours. 

task/sub task not applicable in MS Project 2000

Posted: 20 Jan 2005 07:35 AM PST

Don't know why, but that is exactly what she dpes not want to do - hence teh
question for an alternative

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

Consistent Display of Duration

Posted: 20 Jan 2005 06:45 AM PST

Hi FlyingPM,

<vbg> Thanks very much for the feedback .

Glad to know you are back in the air - here's hoping for no more turbulence
and just remember to keep your safety belt fastened!

Let us know if you can help in the future.

Julie

"TheFlyingPM" wrote:
 

Make Microsoft Project work through Windows CE

Posted: 20 Jan 2005 06:21 AM PST

Hi Cory

to pass feedback onto micrsoft you can send them an email at
com

with the name of the product in the subject line and a "detailed"
explaination (ie business case type thing) of what enhancements you would
like and why .... and you never know ............

Cheers

JulieD



"Cory" <microsoft.com> wrote in message
news:com...
 

Application Error

Posted: 20 Jan 2005 03:45 AM PST

> >John - I created: 1.a Master File with resources to use 

Tom,
Normally a resource pool file contains only resources (no tasks) and
remains separate from the files with tasks that use the shared
resources. However, one of my main test files is a configuration just
like you describe. The master file has the resources and the other files
are inserted subprojects. I have had no problems with this configuration
for over a year.

How do you build the master? There are a couple of ways to effectively
insert subprojects. The preferred method is via Insert/Project although
the Window/New Window method also appears to work, but I've never used
it. As far as saving, long ago I got into the habit of always doing
"Save As" for the master and each of the subprojects. It works for me
although there is a lot of support among other users that a straight
"Save" and "Save all", as you are using, is equally as effective.

You may possibly have corruption in one or more of your files. Try
rebuilding the files. Start by deleting the subproject from the master
and then and saving it as as a .mpd (database). Then reopen the .mpd
file and do a "Save As" to an .mpp. Do the same thing with each of the
subprojects and then rebuild the full master by using the insert method
as noted above.

Hope this helps.
John
Project MVP

Problem with "Export to Excel"

Posted: 20 Jan 2005 02:47 AM PST

Dear all,

I've got a problem with the "export to excel" facility. I want to export
Actual costs spread across months.

For example, I have one activity with an actual cost of £9.5 and 3 months
duration. The ACWP gets exported as £9.5 PER MONTH up to the status date.
The Actual Cost figure gets exported as £9.5 for the first month and then
nothing for the remaining 2 months duration on this activity. What I would
hope to see is the £9.5 prorated across the 3 months duration of this
activity.

Does anybody have any ideas here?

Thanks and regards,
Angus Duncan

where can i find an easy to understand 'which version of project do you need' web page

Posted: 19 Jan 2005 11:11 PM PST

Hi Julie,

Unfortunately, multiple people cannot have the *same* MS Project file open
for editing at the same time. (And AFAIK, not even with server.)

They can use a resource pool setup and each user can have a project file
with their portion of a larger project connected to the pool. Each user can
then update their project file and can update the changes in assignments to
the shared resource pool. The individual project files and be consolidate
through the pool file as needed to view the "master project".

I have a client that sucessfully used the shared pool and multiple project
file setup with about 15 project managers and many more project files.

I think the advantage of Project Server is the ability to allow resources
(and others with sufficient access rights) who don't use MS Project to view
their tasks and provide tracking information. As I am sure you know, Project
Server is a whole other layer of complexity (and cost.)

Hope this helps somewhat.

Julie
The "other other" Julie :-)

"JulieD" wrote:
 

OT: Message for JulieS

Posted: 19 Jan 2005 08:21 PM PST

Hi Julie,

I agree, but then, I try never to bite the hand that feeds me!

Julie

"JulieD" wrote:
 

Time Calculations

Posted: 19 Jan 2005 08:13 PM PST

Thanks, Jan. I'll try it.

"askgail" wrote:
 

Launch MS Access from Project and open a report

Posted: 19 Jan 2005 05:27 PM PST

Thanks Julie, but what they want is to open a particular report in Access
based on the task they are sitting on(or linking from) in Project. I'll let
you know if I come up with a solution.
Thanks!
Marty

"JulieS" wrote:
 

Tracking "Out of Office" Resources

Posted: 19 Jan 2005 03:03 PM PST

Doug, your email address didn't come through properly...

Unable to open entire project via ODBC to SQL server

Posted: 19 Jan 2005 12:41 PM PST

Thanks, but it is not that. It is something to do with the Workstation ID
that stops MS-Project from being able to open the entire project, restricting
it to an import via a map. It seems that only the workstation that created
the project database via MS-Project SaveAs can open it completely.

"Rod Gill" wrote:
 

Creating a team project plan by % worked per month

Posted: 19 Jan 2005 11:01 AM PST

At first glance, getting the total hours by task and resource, or by
resource then task for that matter, is easy. What's a problem is finding
the total hours the resource was scheduled to have worked on both project
and non-project activity so you can compute the percentage. Honestly, I'm
not sure where you're going with it or what the usefulness of these
percentages might be in terms of managing projects. If you could go into a
little more detail about why you're trying to produce this report, maybe
there's a way to get the equivalent information for you in some other way.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"Amy" <microsoft.com> wrote in message
news:com... 

Importing and Exporting

Posted: 19 Jan 2005 11:01 AM PST

Hi Askgail,

Glad to have helped and thanks for the feedback. Let us know if we can
assist you again in the future.

Julie

"askgail" wrote:
 

Heresy - how to prevent Project from calculating/changing dates

Posted: 19 Jan 2005 10:25 AM PST

If you need to track progress etc you really have to have calculation set
on. But how could you possibly enter actual data without changing the plan?
A task was scheduled to start on 15 January. It actually started on 20
January. How can you record the actual data you need to track, in this case
the date it began, without changing the start date?

You also said you need to show dependencies. Taking for discussion the
default FS link, dependencies mean, by the very definition of the word, that
the start time of the successor task is dependent on the finish time of the
predecessor task. There is something in the second task that uses something
produced by the first and until that something exists it is physically
impossible for the 2nd task to start. But in your question you seem to be
saying you want to ignore that scheduling fact, that you want task 2 to be
scheduled on some arbitrary date and stay there even if it means that the
people who will do the work are going to show up and sit around twiddling
their thumbs, waiting and wasting your money doing nothing, for the required
parts or whatever to show up so they can start work. No offense intended,
but this makes absolutely no business sense at all.

If it is required you know what the original plan was, so that you can
compare performance against plan, that is another story all together. After
you create your plan and before starting to post in actuals, you save a
baseline. The baseline is a snapshot of the plan and in the baseline all
the original values of start and finish etc are locked in and preserved even
if different values are subsequently entered in the plan or posted as
actuals later on. Once you have the baseline, it is an easy task to create
a Gantt chart and task table that uses the baseline values rather than the
normal one that uses the scheduled values. As you enter actuals, the
schedule will change but the Gantt chart you're showing isn't using those
values but the locked-down baseline values instead and so will always show
the static plan as originally conceived. How this has any use as a
management tool is beyond me, but you certainly can do it technically.

And the best advice I can give is to keep a second copy of the plan
maintained as it really should be so when the boss who's requiring you to do
this is fired for s****ing up the project and throwing away so many
resources, you can show HIS boss how you would have done it properly and
earn yourself a promotion <grin>.

--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


<com> wrote in message
news:googlegroups.com...