Output color to a text (rtf) file
 

I have a macro that imports every line in a text file, replaces certain
key words, then exports the line to a different text file. I would like
the word I replace to show up in color in the output file. I have
already renamed my files to use the rtf file extension. I have also
changed the font color for the cell's value being used to replace text
in the string. The replacement is being made, but the font properties
are lost.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Output color to a text (rtf) file
 

Bill,
How are you saving as RTF as Excel does not have that option ?

NickHK

"Wild Bill" wrote in message
...
I have a macro that imports every line in a text file, replaces certain
key words, then exports the line to a different text file. I would like
the word I replace to show up in color in the output file. I have
already renamed my files to use the rtf file extension. I have also
changed the font color for the cell's value being used to replace text
in the string. The replacement is being made, but the font properties
are lost.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Output color to a text (rtf) file
 

I name it with a .rtf extension.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!