Hot Fix or SP1 effect on VBA?

[John Horton]

I am using the following code to exchange some task table text to the
assignments table. In other words I have text in at text field in the Gantt
that I want to see in the Resource Usage and Task Usage views. In the past
this was easy. I have used this code for years in 2000 and 2003.

With my personal install w/SP1 the text is transfers in Task Usage but not
Recourse Usage. That does not make any sense as I always though that these
views were just pivots of each other. Both are views of the Usage table!?!
Right?

At the same time it works perfect if I run the code on a box with a “bone
stock†install. As I go from PC to PC it seems that the upgrades are the
issue. Is this possible? Any other ideas ????



Sub SyncWorkOrders()

Dim t As Task
Dim A As Assignment
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
For Each A In t.Assignments

A.Text14 = t.Text14

Next A
End If
Next t
MsgBox "Resource Tables have been syncronized with Task Tables"
End Sub

 

[Rod Gill]

Hi,

I have 2007 SP1 and can confirm the problem. However Project 2003 SP3
displays the same result. I also thought that the data in the 2 usage views
was the same. I'll see what MS says and post back if I hear.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[John Horton]

Still in pain over this. Anyone have any ideas?

Hi,

I have 2007 SP1 and can confirm the problem. However Project 2003 SP3
displays the same result. I also thought that the data in the 2 usage views
was the same. I'll see what MS says and post back if I hear.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[John]

Still in pain over this. Anyone have any ideas?

John,
Live with the pain because this is a new "feature" with Project 2007.
See updated FAQs 51 & 37 on our MVP website at,
http://www.mvps.org/project/faqs.htm

Don't ask us why because we haven't received a good explanation from
Microsoft either.

John
Project MVP

 

[www.projectserver.cz]

You should not use properties TEXTXY with project server, you should
use methods setvalue & getvalue

unfortunatelly this methods are not implemented for assignment object.
So in case that you have SP1 you shoud use property name

For Each A In t.Assignments
A.YourPropertyName =t.getfield