Copy A Task by Unique ID

D

Darren_S15

I am trying to create a new task from an existing task so that all the
original tasks properties are also copied over.

Sounds easy right? Thats what I thought until I realised there are
over 400 properites.

Anyone got any clever ideas how this can be done in VBA?

The issue I ran into was I can select the original task and then set a
new task object to equal this object.

Only this did not behave how I thought as the new task is now the
original task, so any changes I make are on the original task.

Any help...

Thanks,
Darren
 
R

Rod Gill

This vba group is in the process of being closed. Please post future
questions to the .developer group.

To answer your question record a macro of you doing a copy paste of the
whole task. It does unfortunately require you to move the active cell, but
it is the quickest way.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com




Darren_S15 said:
I am trying to create a new task from an existing task so that all the
original tasks properties are also copied over.

Sounds easy right? Thats what I thought until I realised there are
over 400 properites.

Anyone got any clever ideas how this can be done in VBA?

The issue I ran into was I can select the original task and then set a
new task object to equal this object.

Only this did not behave how I thought as the new task is now the
original task, so any changes I make are on the original task.

Any help...

Thanks,
Darren

__________ Information from ESET Smart Security, version of virus
signature database 4601 (20091112) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4601 (20091112) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
M

Mike Glen

Hi Darren,

Try posting on the developer newsgroup as this one is closing down. Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP



I am trying to create a new task from an existing task so that all the
original tasks properties are also copied over.

Sounds easy right? Thats what I thought until I realised there are
over 400 properites.

Anyone got any clever ideas how this can be done in VBA?

The issue I ran into was I can select the original task and then set a
new task object to equal this object.

Only this did not behave how I thought as the new task is now the
original task, so any changes I make are on the original task.

Any help...

Thanks,
Darren
 

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