Previous Topic Next Topic

Microsoft Project and VB - Help

Closed
Schedule_VBN00b - 9 Feb 2009 à 00:41
 Schedule_VBN00b - 9 Feb 2009 à 04:22
Hello,
Related:

1 response

Réponse 1 / 1
diginum Posts 9 Registration date Tuesday 21 October 2008 Status Member Last seen 22 April 2009
9 Feb 2009 à 03:38
hi,
you have not given enough details so as i can find a specific answer for your post.
please post your question again elaborating more on the problem that you need.
thank you.
Schedule_VBN00b
9 Feb 2009 à 04:22
My problem is that when I run the macro (with the excerpt already in the page and attached again below) is that it says that it successfully copies x number of fields but doesnt actually copy the contents of the Percent Complete field into the Text field.
So text field is blank even after the macro runs.

I think I need to convert the percent complete field into a string/text so that it can save in that field. Because Percent complete is in percent format.


Dim t as task
Dim ts as tasks

Set Ts = ActiveProject.Tasks
intTcounter = 0

If not t is nothing then
t.PercentageComplete = t.Text7
intTcounter = intTcounter + 1
End If
next t
'Display message
MsgBox ("Macro done" & Chr(13) & intTcounter & " Task Complete")

End

Similar discussions

product key for microsoft project 2007
msberry -
Ambucias -

1 response