Exporting to Excel

[egun]

I use Excel to send out snippets of giant MS Project files to other engineers
and schedulers for coordination. I already have a nice VBA macro in Project
for exporting a user-selected range of information from Project to Excel. It
does a good job of formatting everything and looks good. The one last thing
I would like to be able to do is grab the color of the font in the Project
cell and transfer that to Excel.

I've searched the NG, but can't quite find the answer to this question:

Is it possible to determine the color of the text in a single cell?

Thanks!

 

[John]

I use Excel to send out snippets of giant MS Project files to other engineers
and schedulers for coordination. I already have a nice VBA macro in Project
for exporting a user-selected range of information from Project to Excel. It
does a good job of formatting everything and looks good. The one last thing
I would like to be able to do is grab the color of the font in the Project
cell and transfer that to Excel.

I've searched the NG, but can't quite find the answer to this question:

Is it possible to determine the color of the text in a single cell?

Thanks!

egun,
No and yes. No, the font color, (or any font attributes for that
matter), are write only parameters. However, if there is some rhyme and
reason for the color scheme (versus random colors), whatever criteria
was used to apply the colors can be used in reverse to decode them. That
information can then be applied to the Excel data.

Hope this helps.
John
Project MVP

 

[egun]

Thanks.

It helps, in that it answers my question. It doesn't help, because there is
no rhyme or reason to the colors - they are the engineer's way of
communicating changes to each other.

Eric

 

[Rod Gill]

You could use Flag fields to set the status of tasks and use that to
automatically via an VBA macro color the text and via Bar styles color the
bars and to control how the macro colors the Excel cells.

 

[John]

Thanks.

It helps, in that it answers my question. It doesn't help, because there is
no rhyme or reason to the colors - they are the engineer's way of
communicating changes to each other.

Eric

Eric,
Hey, don't tell me there is no rhyme or reason to the way an engineer
thinks. Engineers are very logical and precise. I know cuz I are one.

Seriously though, if you can get the criteria used by each engineer then
you will be all set. And if some of the guys use conflicting criteria,
all it means is that the task will be more challenging.

John