Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Apr 2004
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pasting Text in Excel Doc (excel 2000)

    There seems to be two types of pasting for windows apps, Paste and Paste Special.

    If I copy text from an email into an Excel doc using Paste, the font
    and text size of the source document (email) is maintained. It can be
    changed later of course, but it comes in as that of the source doc.

    If I copy text from email to Excel using Paste Special, I can specify
    'Text', allowing the font and size to arrive matching the font and
    size of the rest of the Excel doc, and thus eliminate the need to
    modify it later.

    It seems there should be a way of locking in the 'Text' option for
    paste mode so that I can avoid the extra clicks involved with using
    Paste Special.

    These extra clicks wouldn't be a big deal except that I'm copying
    hundreds of mailing addresses from email to Excel, and would much
    prefer using the very quick CTRL+C and CTRL+V combination.

    In case it's of any importance, I'm using Windows XP.
    Thanks in advance for any help.

    Patrice_29

  2. #2
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting Text in Excel Doc (excel 2000)

    Patrice,

    Here's the VBA line that will do it: <font face="Georgia">ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False</font face=georgia>. Make a Macro button and attach this code.

    The quick way to write some code that is at least close to what you want is to use the Tools - Macro - Record New Macro... menu. Use a name that describes your activity - "PasteText") You can also make a key comjbination similar to Ctrl-V in this window. After you perform the task once, you have a macro written. (Open the Visual Basic Editor to see it. You might want to make some changes, if you know how.)

    Finally, Customize the tool bar. Slide a "Macros" button (It's a <img src=/S/smile.gif border=0 alt=smile width=15 height=15>, grandperson of all the smileys) onto the toolbar. Now right click on the new button, and change or edit the button image. Also at the bottom of this menu, you'll see "Assign Macro...". Connect the button to the PasteText Macro here, and you're just one click away from happiness!

    Errol

  3. #3
    New Lounger
    Join Date
    Apr 2004
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting Text in Excel Doc (excel 2000)

    Thanks so much Errol. I'll try that out!

  4. #4
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting Text in Excel Doc (excel 2000)

    Oh, yeah! <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23>

    Welcome to Woody's Lounge, Patrice!. <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Be sure to browse Scuttlebutt for some very interesting & enjoyable topics!

    Errol

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •