|
View Full Version : Drag and Drop a task in VBA
Hi,
I want to know if it is possible to drag and drop a task between two others
task in VBA and if it is, which command I have to use.
I don't want to do a cut/paste because my moved task losted its
dependencies.
thank's for your help.
Pierre L.
|
Hi Pierre,
Try posting on the developer newsgroup as this one's 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
pleb wrote:
> Hi,
>
> I want to know if it is possible to drag and drop a task between two
> others task in VBA and if it is, which command I have to use.
>
> I don't want to do a cut/paste because my moved task losted its
> dependencies.
>
> thank's for your help.
> Pierre L.
|
I think you need to do a copy/paste, then copy the dependencies then delete the old task. Of more importance in some macros is that you lose the Unique ID as all new tasks get a new Unique ID. Another way is to insert the Number1 column and copy the ID field to it. Then renumber the tasks into the order you want and sort with automatic renumber on by Number1. Keep a copy of the ID field in Number2 if you might need to restore the original layout. -- Rod Gill Project MVP Visit www.msproject-systems.com for Project Companion Tools and more "pleb" wrote in message
news:eCkcTz5QGHA.1688@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I want to know if it is possible to drag and drop a task between two
> others task in VBA and if it is, which command I have to use.
>
> I don't want to do a cut/paste because my moved task losted its
> dependencies.
>
> thank's for your help.
> Pierre L.
>
|
Hi Pierre,
Try posting on the developer newsgroup as this one's 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
pleb wrote:
> Hi,
>
> I want to know if it is possible to drag and drop a task between two
> others task in VBA and if it is, which command I have to use.
>
> I don't want to do a cut/paste because my moved task losted its
> dependencies.
>
> thank's for your help.
> Pierre L.
|
thank's I go there Now.
"Mike Glen" a écrit dans le message de news:
Ow9Z$J8QGHA.4688@TK2MSFTNGP11.phx.gbl...
> Hi Pierre,
>
> Try posting on the developer newsgroup as this one's 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
>
>
> pleb wrote:
>> Hi,
>>
>> I want to know if it is possible to drag and drop a task between two
>> others task in VBA and if it is, which command I have to use.
>>
>> I don't want to do a cut/paste because my moved task losted its
>> dependencies.
>>
>> thank's for your help.
>> Pierre L.
>
>
>
|
I think you need to do a copy/paste, then copy the dependencies then delete the old task. Of more importance in some macros is that you lose the Unique ID as all new tasks get a new Unique ID. Another way is to insert the Number1 column and copy the ID field to it. Then renumber the tasks into the order you want and sort with automatic renumber on by Number1. Keep a copy of the ID field in Number2 if you might need to restore the original layout. -- Rod Gill Project MVP Visit www.msproject-systems.com for Project Companion Tools and more "pleb" wrote in message
news:eCkcTz5QGHA.1688@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I want to know if it is possible to drag and drop a task between two
> others task in VBA and if it is, which command I have to use.
>
> I don't want to do a cut/paste because my moved task losted its
> dependencies.
>
> thank's for your help.
> Pierre L.
>
|
You're welcome, Pleb and good luck! :-)
Mike Glen
MS Project MVP
pleb wrote:
> thank's I go there Now.
>
> "Mike Glen" a écrit dans le message de news:
> Ow9Z$J8QGHA.4688@TK2MSFTNGP11.phx.gbl...
>> Hi Pierre,
>>
>> Try posting on the developer newsgroup as this one's 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
>>
>>
>> pleb wrote:
>>> Hi,
>>>
>>> I want to know if it is possible to drag and drop a task between two
>>> others task in VBA and if it is, which command I have to use.
>>>
>>> I don't want to do a cut/paste because my moved task losted its
>>> dependencies.
>>>
>>> thank's for your help.
>>> Pierre L.
|
thank's I go there Now.
"Mike Glen" a écrit dans le message de news:
Ow9Z$J8QGHA.4688@TK2MSFTNGP11.phx.gbl...
> Hi Pierre,
>
> Try posting on the developer newsgroup as this one's 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
>
>
> pleb wrote:
>> Hi,
>>
>> I want to know if it is possible to drag and drop a task between two
>> others task in VBA and if it is, which command I have to use.
>>
>> I don't want to do a cut/paste because my moved task losted its
>> dependencies.
>>
>> thank's for your help.
>> Pierre L.
>
>
>
|
You're welcome, Pleb and good luck! :-)
Mike Glen
MS Project MVP
pleb wrote:
> thank's I go there Now.
>
> "Mike Glen" a écrit dans le message de news:
> Ow9Z$J8QGHA.4688@TK2MSFTNGP11.phx.gbl...
>> Hi Pierre,
>>
>> Try posting on the developer newsgroup as this one's 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
>>
>>
>> pleb wrote:
>>> Hi,
>>>
>>> I want to know if it is possible to drag and drop a task between two
>>> others task in VBA and if it is, which command I have to use.
>>>
>>> I don't want to do a cut/paste because my moved task losted its
>>> dependencies.
>>>
>>> thank's for your help.
>>> Pierre L.
|
Hi Pierre,
Try posting on the developer newsgroup as this one's 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
pleb wrote:
> Hi,
>
> I want to know if it is possible to drag and drop a task between two
> others task in VBA and if it is, which command I have to use.
>
> I don't want to do a cut/paste because my moved task losted its
> dependencies.
>
> thank's for your help.
> Pierre L.
|
I think you need to do a copy/paste, then copy the dependencies then delete the old task. Of more importance in some macros is that you lose the Unique ID as all new tasks get a new Unique ID. Another way is to insert the Number1 column and copy the ID field to it. Then renumber the tasks into the order you want and sort with automatic renumber on by Number1. Keep a copy of the ID field in Number2 if you might need to restore the original layout. -- Rod Gill Project MVP Visit www.msproject-systems.com for Project Companion Tools and more "pleb" wrote in message
news:eCkcTz5QGHA.1688@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I want to know if it is possible to drag and drop a task between two
> others task in VBA and if it is, which command I have to use.
>
> I don't want to do a cut/paste because my moved task losted its
> dependencies.
>
> thank's for your help.
> Pierre L.
>
|
thank's I go there Now.
"Mike Glen" a écrit dans le message de news:
Ow9Z$J8QGHA.4688@TK2MSFTNGP11.phx.gbl...
> Hi Pierre,
>
> Try posting on the developer newsgroup as this one's 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
>
>
> pleb wrote:
>> Hi,
>>
>> I want to know if it is possible to drag and drop a task between two
>> others task in VBA and if it is, which command I have to use.
>>
>> I don't want to do a cut/paste because my moved task losted its
>> dependencies.
>>
>> thank's for your help.
>> Pierre L.
>
>
>
|
You're welcome, Pleb and good luck! :-)
Mike Glen
MS Project MVP
pleb wrote:
> thank's I go there Now.
>
> "Mike Glen" a écrit dans le message de news:
> Ow9Z$J8QGHA.4688@TK2MSFTNGP11.phx.gbl...
>> Hi Pierre,
>>
>> Try posting on the developer newsgroup as this one's 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
>>
>>
>> pleb wrote:
>>> Hi,
>>>
>>> I want to know if it is possible to drag and drop a task between two
>>> others task in VBA and if it is, which command I have to use.
>>>
>>> I don't want to do a cut/paste because my moved task losted its
>>> dependencies.
>>>
>>> thank's for your help.
>>> Pierre L.
|
|
|
|