Programming Hammock Tasks

B

bbordiuk

Is there any way to create hammock tasks in code other than by using
screen/selection-oriented methods such as EditPasteSpecial? I'm trying
to write code in VB6 that allows users to create hammocks by
identifying the start and end tasks for the hammock. I then want to
link the start, actual start, end, and actula finish dates of the
tasks to a hammock. I can't find any info on VBA methods to do this
other than to select the fields on-screen and use Edit Paste Special.

Another interesting thing I've noticed about hammocks is that the
linked fields don't seem to be updated while my VB code is running. I
can calculate the project, changing the dates of the start and end
tasks but thlinks don't update until whatever code I have running is
finished. Is there a method that updates the links?

Thanks,

Bill B
 
J

John

Is there any way to create hammock tasks in code other than by using
screen/selection-oriented methods such as EditPasteSpecial? I'm trying
to write code in VB6 that allows users to create hammocks by
identifying the start and end tasks for the hammock. I then want to
link the start, actual start, end, and actula finish dates of the
tasks to a hammock. I can't find any info on VBA methods to do this
other than to select the fields on-screen and use Edit Paste Special.

Another interesting thing I've noticed about hammocks is that the
linked fields don't seem to be updated while my VB code is running. I
can calculate the project, changing the dates of the start and end
tasks but thlinks don't update until whatever code I have running is
finished. Is there a method that updates the links?

Thanks,

Bill B

bbordiuk,
No, as far as I know the only way to implement the EditPasteSpecial
Method is via foreground processing (i.e. screen selection oriented).
However, you indicate you want to link in several dates as part of the
hammock task. Paste links are fragile and easily corrupted even as
single links. Combining several field cells into the link chain only
compounds that issue. Further, paste links require a lot of discipline
to maintain and in my experience, most general users do not have that
discipline. I suggest you re-visit your desire to have complex hammock
tasks for your general users.

With regard to updating paste links when the code runs, I don't know
because I've never tried it. If using the CalculateAll Method does not
work, then my guess is that you may need to manually calculate after
your code is finished.

John
Project MVP
 

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