J
Jeff
I am using Jack Dahlgren's code from his site. I want it to churn
throught the the custom enterprise fields instead of just the local
fields.
I have modified the code but I get a "Compile Error" at "Dim pts As
pjTaskEnterprise". the body of the code looks like this:
myType = "Text"
For i = 1 To 30
mycheck = False
it = 0
While Not mycheck And (it < pts.Count)
it = it + 1
If Not pts(it) Is Nothing Then
If pts(it).GetField(FieldNameToFieldConstant_
myType & i, pjTaskEnterprise)) <> "" Then
XlRng = myType & CStr(i)
Set XlRng = XlRng.Offset(1, 0)
mycheck = True
End If
End If
Wend
Next i
throught the the custom enterprise fields instead of just the local
fields.
I have modified the code but I get a "Compile Error" at "Dim pts As
pjTaskEnterprise". the body of the code looks like this:
myType = "Text"
For i = 1 To 30
mycheck = False
it = 0
While Not mycheck And (it < pts.Count)
it = it + 1
If Not pts(it) Is Nothing Then
If pts(it).GetField(FieldNameToFieldConstant_
myType & i, pjTaskEnterprise)) <> "" Then
XlRng = myType & CStr(i)
Set XlRng = XlRng.Offset(1, 0)
mycheck = True
End If
End If
Wend
Next i