Re: Copying text from Code module and pasting into MS Word

From: Cindy M -WordMVP- (C.Meister-C_at_hispeed.ch)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 16:52:12 +0100

Hi Bill,

> when you copy text from a code module in
> Excel and paste it in Word, the commented text does not remain green (or
> whatever color is set in the "options" tab)?
>
Paste it into a Word document (as I think you said somewhere): that's
correct. It will all be the same color.

If you paste it into a Word VBA module, then it will be colored (mostly red
or green, most likely).

As the others have said, the colors you see are a function of the
application window displaying the text. The formatting is not part of the
text, itself.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Relevant Pages

  • Re: Create a User Defined Field in Word so that I can reference fr
    ... within the Word document that I can then access via the Excel application.. ... A form field would be a possibility, but then the document would have to be ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.docmanagement)
  • Re: excel to word via vba button
    ... If you want to do this with a button in Excel, ... Please reply to the newsgroup unless you wish to avail yourself of my ... Is there a way to send spreadsheet data to a word document using VBA code? ...
    (microsoft.public.word.vba.userforms)
  • Re: Conversion from Works
    ... ask in a Works or Excel newsgroup. ... Microsoft's Legal Users' Guide) ... > Is there any way to convert this document to a Word document (or otherwise ...
    (microsoft.public.word.newusers)
  • Re: word 2003 hangs during merge to excel spreadsheet
    ... Could be file corruption in either word or Excel, ... trying this with the same Word document? ... > point of completing the merge. ... reply in the newsgroup and not by e-mail :-) ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How do I print a graphic in a .doc file?
    ... > I got a .doc file as an attachment in an e-mail. ... Open the Word document in Word, then go to Tools/OPtions/Print and check ... Cindy Meister ... reply in the newsgroup and not by e-mail :-) ...
    (microsoft.public.word.docmanagement)