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