Milestones not releasing their property when changed to tasks

S

sad

I am exporting data to excel and when my routine comes across a milestone

For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
Set xlRow = xlRow.Offset(1, 0)
Set xlCol = xlRow.Offset(0, t.OutlineLevel)
xlCol = t.Name
If t.Summary Then
xlCol.Font.Bold = True
End If

It treats it as if it were a summary task and fails to import any of the
details associated with the task. To mak matters worse, if I remove the
designation of milestone from the task, it somehow retains the property and
it gets imported just like a summary task.

Does Project 2003 save this information someplace else. If so can I get to
it and change the flag?

Thanks
 
Q

qw

Sorry about that, Our posting system to the newsgroups for work is through a
custom web client that assigns names and such so that our corporate email is
not flodded with spam
 
J

John

Jeff,
Don't cross post and please don't use different posting names just to
get the same message out. If you post the same message to more than one
group you are effectively wasting our time because while one MVP is
answering one post another may be answering the duplicate. We are glad
to help those who have questions but we are all volunteers but our time
does have value.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top