transfer formatting tasks between projects

[R.Rethfeldt]

Hello! I would like to copy data from a project into another. However the
formatting are lost in the columns. I try to transmit the data over the task
object in a For each instruction. With FormatCopy or FormatPaint it does not
go... as can I formatting (fat, italic, color) from the active cell pick out
and to the new project transfer?

 

[John]

Hello! I would like to copy data from a project into another. However the
formatting are lost in the columns. I try to transmit the data over the task
object in a For each instruction. With FormatCopy or FormatPaint it does not
go... as can I formatting (fat, italic, color) from the active cell pick out
and to the new project transfer?

R Rethfeldt,
You are correct that copy and paste, whether done manually or via VBA,
does not retain font characteristics. Using VBA to copy data from one
project to another may be appropriate but it depends on what you are
trying to do. We could be of more help if you explained what you are
trying to do rather than how you are trying to do it.

John
Project MVP

 

[R.Rethfeldt]

Hello John! Ms Project is used at a customer for the scheduling by orders at
machines. Orders (tasks) are transferred by a machine to another. The order
is not yet finished at the machine is posed as marking of the task in the
bold print. I must consider these formatting when transferring the orders
from a machine to another. Question: How can text formatting of a data
field be queried? I know that these formatting with the appropriate view are
stored. But with which code select to this formatting and this approaches
can? R.Rethfeldt

 

[John]

Hello John! Ms Project is used at a customer for the scheduling by orders at
machines. Orders (tasks) are transferred by a machine to another. The order
is not yet finished at the machine is posed as marking of the task in the
bold print. I must consider these formatting when transferring the orders
from a machine to another. Question: How can text formatting of a data
field be queried? I know that these formatting with the appropriate view are
stored. But with which code select to this formatting and this approaches
can? R.Rethfeldt

R.Rethfeldt,
I'm sorry but I'm not quite following what your process does. "The order
is not yet finished at the machine is posed as marking of the task in
the bold print"??? I think something is getting lost in translation.

However, to answer your basic question. Font properties are
unfortunately read only. But that doesn't mean the properties are
indeterminable. Some criteria is used to set those properties. For
example, the text color may be changed when the task is 100% complete.
In that case the text color can be determined but not by querying the
font property direct but rather by querying the % Complete field.

Hope this helps.
John
Project MVP