Pages

Search

Initialzing VBA variables for use as constants? Microsoft Project

Initialzing VBA variables for use as constants? Microsoft Project

Initialzing VBA variables for use as constants?

Posted: 19 Sep 2005 10:06 PM PDT

Exactly, thanks.


"Rod Gill" <rod AT project-systems DOT co DOT nz> wrote in message
news:phx.gbl... 
or 
for 

Free Slack calculation?

Posted: 19 Sep 2005 06:50 PM PDT

Hi,

To my knowledge it is the normal calculation rule as published anywhere just
that it takes into account constraints and deadlines.
If you want to rule these out I'm afraid you shouldn't enter any :-)

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"G Lykos" <com> schreef in bericht
news:phx.gbl... 
And 
no 
it 
all 
the 

Calendar durations (again)

Posted: 19 Sep 2005 07:58 AM PDT


Hi Martin,

Can't you use a lag of 52 weeks or 365 days?

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
MS Project MVP

Jan De Messemaeker wrote: 

Can I build a Technology Roadmap using Microsoft Project?

Posted: 19 Sep 2005 06:16 AM PDT


OK, Alan, but what have you done and what can't you do? Please be more
specific!


Mike Glen
Project MVP




Mapper2 wrote: 

Problems with a filter in VBA

Posted: 18 Sep 2005 11:58 PM PDT

In article <googlegroups.com>,
com wrote:
 

Ron,
If you want to use VBA why not do everything in VBA (i.e. create the
filter, automatically set the two week window and print each resource's
report)? Without actually testing your code out, it seems to me there is
a basic flaw in the implementation. The code loops through each
resource. As it loops it applies a filter but that filter appears to be
a task filter when in fact it should probably be a resource filter (at
least that might explain why the "name" portion doesn't work - in a task
filter resources are identified by the "Resource Names" field while in a
resource filter resources are identified by the "Name" field).

Instead of looping through resources why not loop through tasks. Set the
filter (using the FilterEdit Method) to look for all tasks that have a
Start date less than or equal to a date two weeks from the current date
or a Finish date less than or equal to a date two weeks from the current
date and a Resource Name that is modified automatically each time
through the print loop. It might even be beneficial to sort the whole
file by Resource Names (do not keep outline structure) before applying
the filter. I suggest looping through tasks instead of resources because
filtering on resource dates may give tasks (assignments) outside the
range of interest (remember, resource start and finish dates span the
resources entire assignment period).

As far as not printing blank pages when no assignments appear for a
particular resource in the time span, a selected set construct can be
used, for example:
On Error Resume Next
SelectTaskColumn
Set Area = ActiveSelection.Tasks
If Err > 0 then
[skip printing]
On Error GoTo 0 'clears error
Else
[print]
End if

Hope this helps.
John
Project MVP

How is actual duration calculated at the project summary level?

Posted: 17 Sep 2005 06:57 AM PDT

Thanks, Steve.

"Steve House [Project MVP]" wrote:
 

Duration vs. Start / Finish

Posted: 16 Sep 2005 04:28 PM PDT

hi James,

Enter 4hrs in the work field. Change the task type to fixed duration and
make the duration field 1 week - Start date to Mon 8/29/05 and the Finish
date to Fri 9/2/05.

Following is the link where you can explore the basics of scheduling in
Microsoft Project:

http://office.microsoft.com/en-us/assistance/HA010211711033.aspx


Kind regards,
--------------
Haris
http://www.manage-systems.com
---------------------------------------

"James" wrote:
 

resource and materials planning

Posted: 16 Sep 2005 07:25 AM PDT


HI Bob,

This might work: In the Resource Sheet, create a new resource "Steel
Pillars". Enter it as a resource Type: Work and make the Max. Units 100.
Now, for each task requiring the pillars, change the Task Type to Fixed
Units and Uncheck Effort Driven. Now enter Units as the number of pillars
required for that task.

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #5 & 10 on Resources, 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



material bob wrote: 

reschedule uncompleted work in Microsoft 2002 with constrainst?

Posted: 15 Sep 2005 09:31 AM PDT


Hi dalbaugh,

Well, I thought that scheduelling from the start would remove the
constraints produced by scheduelling from the finish that are preventing the
August hours from being pushed forward to September. Did you try that?
Alternatively, select all the tasks and then in Task Information, reset all
constraints to As Soon As Possible.

Mike Glen
Project MVP




microsoft.com wrote: