problems accessing BaseLine Work thru VBA in Microsoft Project Server

Microsoft Project

    Next

  • 1. workload issue
    I want to write a macro to check whether workload uses 'days', 'hrs', 'wks', 'mins', or 'mons'. then what ever it uses, it changes the workload to 'hrs'. I want to use OptionsSchedule workunits:=5 but how I can check....thanks
  • 2. Open resource pool
    I am trying to use the following code to open the resource pool as read write, but I still get prompted on how to open it. What should I change? Dim projapp As MSProject.Application Dim curr_pool As String curr_pool = "<" & proj_db & ">\resourcepool" Set projapp = CreateObject("MSProject.Application") 'OPEN THE RESOURCE POOL TO ATTACH ALL THE OTHER PLANS projapp.FileOpen Name:=curr_pool, FORMATID:="MSPROJECT.MPD", ReadOnly:=False -- Yours Fictionally, Biggles
  • 3. webdav & office 2007
    I use WebDav in some application when the client open the webfolders the contents of t he folder doesn't displayed with its names correctly,it displayed with IDS of these items, this often occurred if the client machine has office 2007 but if he installed office 2003 it's appeared correctly. I think office 2007 upgrade MSDAIPP.dll to version 12.x which make the issue appeared,I noticed that on machines that it work the dll version is 11.x. Does any one help me with this issue? Thanks
  • 4. Write Project Custom Field (c#, psi)
    Hello, how do i write a project custom field using c# and psi. (it`s not an project add-in). I already get the guid from the project custom field. But how do i proceed? Thanks a lot for your help!
  • 5. syntax of the DateDifference method
    Hello, What is the syntax of the DateDifference(StartDate, FinishDate, Calendar) method. Especially, how to write the calendar name : between quotes? commas,... The following sub returns an error : incompatibility of type. Thanks Sub Dur() Dim Deb As Date Dim Fin As Date Deb = ActiveCell.Task.Start Fin = ActiveCell.Task.Finish Debug.Print Application.DateDifference(Deb, Fin, "Standard") / 420 End Sub

problems accessing BaseLine Work thru VBA in Microsoft Project Server

Postby Jakub Skopal » Thu, 03 Nov 2005 16:19:43 GMT

Hello Everybody,

We're trying to customize Microsoft Office Project 2003 application with 
VBA macros. Our macro needs to update BaseLine work associated with a 
Resource for each day/month/year. The macro now contains code, which can 
be summarized as:

ActiveProject.Resources.UniqueID(1).TimeScaledData( _
   StartDate:="31.10. 2005 0:00", _
   EndDate:="1.11. 2005 0:00", _
   Type:=pjResourceTimescaledBaselineWork, _
   TimeScaleUnit:=4, _
   Count:=1).Item(1).Value = 120

which should effectivelly set value into "31 oct 2005" cell of baseline 
work to "2hours". The trouble is, that it does not set the value when 
the respective resource is taken from Enterprise Resource Pool. We can 
check, that the value is _somewhere_ by:

MsgBox ActiveProject.Resources.UniqueID(1).TimeScaledData( _
   StartDate:="31.10.2005 0:00", _
   EndDate:="1.11. 2005 0:00", _
   Type:=pjResourceTimescaledBaselineWork, _
   TimeScaleUnit:=4, _
   Count:=1).Item(1).Value

which prints back "120". But it is not visible in the GUI. Viceversa, if 
I set a value of baselinework via GUI, I cannot access it via script.

Is there a solution to this, please?

thank you in advance,
Jakub Skopal

p.s. Please forward your replies to my mail address as well. Thank you.

Similar Threads:

1.problems accessing BaseLine Work thru VBA

Hello,
We're trying to customize Microsoft Office Project 2003 application with VBA 
macros. Our macro needs to update BaseLine work associated with a Resource 
for each day/month/year. The macro now contains code, which can be summarized 
as:

ActiveProject.Resources.UniqueID(1).TimeScaledData(StartDate:="31.10. 2005 
0:00", EndDate:="1.11. 2005 0:00", Type:=pjResourceTimescaledBaselineWork, 
TimeScaleUnit:=4, Count:=1).Item(1).Value = 120

which should effectivelly set value into "31 oct 2005" cell of baseline work 
to "2hours". The trouble is, that it does not set the value when the 
respective resource is taken from Enterprise Resource Pool. We can check, 
that the value is _somewhere_ by:

MsgBox ActiveProject.Resources.UniqueID(1).TimeScaledData(StartDate:="31.10. 
2005 0:00", EndDate:="1.11. 2005 0:00", 
Type:=pjResourceTimescaledBaselineWork, TimeScaleUnit:=4, 
Count:=1).Item(1).Value

which prints back "120". But it is not visible in the GUI. Viceversa, if I 
set a value of baselinework via GUI, I cannot access it via script.

Is there a solution to this, please?


2.How can i access Projects on a Project Server via VBA

How can i load a project from a Project Server via VBA from adifferent 
application. 
It works if i start  Project  PRO by hand and login into the server.  But 
when i start  Project  via VBA and want  to load a Project from Project 
Server  a see no possibilty to do the login .   You can pass a password and 
db username with the fileOpen command but this was not successful yet .  

3.Problem Updating Actual Work Thru Collaboration

I'm using E-mail collaboration with Project 2003.  

I get weekly updates from each resource that contains the Actual Work in 
hours for each day and the Remaining Work for each task.  These are the 
editable fields in the Progress Request form that's attached to the e-mail I 
send.

What I'm finding, however, is that the Actual Work value in the Project file 
is being overwritten with the current week's hours rather than accumulating 
the hours week-to-week.  

For example, I have a task with a baseline of 17 hours of Work.  Upon 
receipt of my Progress Request for week 1, a resource enters 8 hours of 
Actual Work toward that task and changes the Remaining Work to 9 hours since 
the original estimate of 17 hours still looks good (Remaining Work would be 
increased or decreased if the task required more or less time to accomplish). 
 When I get the e-mail reply from the resource, I update the project and the 
Work, Remaining Work and Actual Work values for the task are properly changed 
in the Project file.

For the Progress Request for week 2, the resource enters 1 hour of Actual 
Work for the task and changes the Remaining Work to 8 hours.  (Remember that 
this task has 17h of Work, 9h of Remaining Work and 8h Actual Work from week 
1.)  

After updating project with this information, I would expect the following 
for the task:  
	Actual Work- 9h <the cumulative result of two weeks of effort>;
	Remaining Work- 8h <as entered by resource>;
	Work- 17h <the sum of the two previous values; unchanged from week 1, since 
the resource still felt the task was on schedule>.

What I get is:
	Actual Work- 1h <ONLY the current week's effort>;
	Remaining Work- 8h <as entered by resource>;
	Work- 9h <the sum of the two previous values>.

To compensate for this problem, I've been manually entering the weekly hours 
using the Task Usage view, but this causes problems synchronizing information 
between me and the resources.

Does anyone know why this problem occurs or how to fix it?  Thanks.

-- 

-Mike

4.Is this group the same one I access thru the Microsoft Technical Forums

If not then why are there two. Seeing as the Forums are accessible
right from the menu in VS 2005 I like going there. But I seem to get
answers quicker here in the groups.

5.Accessing Baseline date from VBA

Hello,
I have no problems accessing the baseline dates for any task or resource in 
my schedules, my question is not about that.
When I save an updated baseline MSP shows me the date that the original 
baseline was set.
It is possible in VBA to access (or even overwrite) this date without 
affecting the other baseline  values.
Thanks 


6. Microsoft Project cannot access the Microsoft Project Server

7. Align frame text baseline with anchor text baseline

8. VBA Microsoft Access and SQL Server



Return to Microsoft Project

 

Who is online

Users browsing this forum: No registered users and 10 guest