Pages

Search

"Export to Excel" by Jack Dahlgren Microsoft Project

"Export to Excel" by Jack Dahlgren Microsoft Project

"Export to Excel" by Jack Dahlgren

Posted: 10 Nov 2005 07:51 AM PST

Yep.
Scott, you will benefit from opening the project help and reading about the
object model.
Once you understand it you can do just about anything, or at least know when
what you want to do is impossible.

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..
"John" <com> wrote in message
news:microsoft.com... 
file in 

Custom Formula "#ERROR"

Posted: 10 Nov 2005 07:22 AM PST

Is there something wrong with 4928781.28?
There are a couple of ways to deal with "NA" in a calculated field.
This post describes how:
http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html

iif([Finish] = projdatevalue("NA"), ...
is the key to sorting it out.

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..
"scott_hanebutt" <microsoft.com> wrote in message
news:com... 
"#ERROR" I 
formula 
show 
other 
display in 
blank or if 
use 
be 
prefer 

Filling a number or text field

Posted: 10 Nov 2005 06:21 AM PST

Seconded. Cut and paste from excel is a great method.
You CAN drag (fill down) the same value in project. The keyboard shortcut
CTRL_D will also do the same in Project as it does in Excel.

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..
"Chris Marriott" <microsoft.com> wrote in message
news:com... 
custom 
Excel?

schedule project task 5 days before implementation

Posted: 10 Nov 2005 05:46 AM PST

Hello Gerard,

Yes, that works. I started playing around with lags after I submitted my
initial note and it does the trick. Thanks for the quick response.

Earl

"Gérard Ducouret" wrote:
 

Creating a new view!

Posted: 10 Nov 2005 04:41 AM PST

Take one of your text fields (Text 1, Text 2...) and put an "X" in for the
task you want to set a filter on. Crude but it will work.

"New2Project" wrote:
 

How to bring back the adjust date macro button in Project 2003

Posted: 10 Nov 2005 04:31 AM PST

Great Chris,

should've thought of that. It worked great indeed.

"Chris Marriott" wrote:
 

Assigning mulitiple resources to a task

Posted: 10 Nov 2005 03:10 AM PST

JulieS ... thanks ... what I did was assign the most restricted calendar to
the task (task information/advanced) and checked the box "Scheduling ignores
resource calendars". Similar to what you were suggesting. It seems to have
worked. Thanks for your help.

"JulieS" wrote:
 

Import into Project actual hours worked from Excel

Posted: 09 Nov 2005 07:02 PM PST

Hello,
It's quite easy if you have only one resource on each task. It'll need VBA
development if you have several resources by tasks.
In the first case: File / Open / Type : Microsoft Excl Workbook(xls)
Then create a map between the Excel columns and the Project columns. this
map should include the Unique ID field to use it as the Merge Key.

Hope this helps,

Gérard Ducouret

"sjalbo" <microsoft.com> a écrit dans le message de
news:com... 
collecting 
Project's 

Construction Industry: Help on identifing tasks

Posted: 09 Nov 2005 11:21 AM PST

Insert a text column (insert menu / column)
Put the room number in the text column.
You should have about 2500 tasks (1 for each activity in each room)
From the project menu, select "group by" and define a new group based on
your text field.
That way you can go back and forth between the way you have your project
organized by task or by
room.

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..
"bill" <microsoft.com> wrote in message
news:com... 
a 
21 
I 
numbers. 
related 

My client does not have MP, can I share gnatt in Excel?

Posted: 09 Nov 2005 11:18 AM PST

Hi Kristi,

Welcome to this Microsoft Project newsgroup :-)

Please see FAQ Item: 16. Project Viewer.

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

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

Mike Glen
Project MVP

Kristi wrote: 

Leveling project tasks

Posted: 09 Nov 2005 10:29 AM PST

For info
Problems detected in the file:
- Assigning resources to task and its summary task
- Assigning a resource for more than its max units to a task
Greetings,


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> schreef in bericht
news:phx.gbl... 
(must 
DOT 

Assingment-Dimension evaluated in a Cube

Posted: 09 Nov 2005 07:41 AM PST

"Chris Marriott" wrote: 

Hi Chris,

thanks a lot. As far as I know about the olap extension is that I can see
the tasks in the Cube. That's allright. But I need information about the
assigntments - e.g. we have a task with 10 days and two assigned ressources.
On ressoure in intern the other extern. I now wanna know how much the intern
ressource (information from the ressource outline code) and how much the
extern ressource worked on that task.

Is it possible with the cube extension to see that?

Kind regards

Michael


 

Linking Summary tasks

Posted: 09 Nov 2005 07:03 AM PST

In article <phx.gbl>,
"JackD" <momokuri@gmail> wrote:
 

Jack,
Wow, coming from you, I feel honored.

John

how does project work out a critical task?

Posted: 09 Nov 2005 06:49 AM PST

Hi New2Project ,

Welcome to this Microsoft Project newsgroup :)

You might like to see how a critical path is built up here:
http://www.mvps.org/project/networkysis.htm.

Also, you might like to have a look at my series on Microsoft Project in the
TechTrax ezine, 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 articles 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

wrote: 

link two custom date columns

Posted: 09 Nov 2005 06:30 AM PST

Hello Jan and thank you for your advise
I plugged in ProjDateAdd(Date1,2) and the results is the same day that
appears in the Date 2 column.
Obviousely I am doing somthing wrong. Please advise Thank you

"Jan De Messemaeker" wrote:
 

Page breaks inserted in Gantt chart have no effect

Posted: 08 Nov 2005 11:29 PM PST

Don't forget to check Manual Page Breaks in Print dialog box