|
|
|
|
|
|
Word
|
Pasting as Unformatted Text
|
|
Ease of Use
|
Easy
|
Version tested with
|
|
Submitted by:
|
Anne Troy
|
Description:
|
Remove unwanted paragraph and other formatting that comes over when you copy from the web and paste into Word.
|
Discussion:
|
Many people are frustrated because they copy from a web page and, when pasted into Word, get unwanted paragraph spacing and other formats. Using Edit-Paste special-Unformatted text makes the newly pasted text take on the paragraph formatting that is currently applied at the insertion point, which is usually the desired format. This little macro can speed up the process of using Edit-Paste special-Unformatted text. We show you how to add this macro to normal.dot so that you can use it in any Word document on your PC instead of having to copy the macro into all documents in which you wish to use it.
|
Code:
|
instructions for use
|
Sub PasteSpec()
Selection.PasteSpecial Link:=False, DataType:=wdPasteText
End Sub
|
How to use:
|
- Open Word
- Hit Alt+F11 to get to the Visual Basic Editor (VBE)
- On the left, double-click Normal.dot (or it may say just "normal")
- From the menu, choose Insert-Module.
- Paste or type the code above into the code window at the right of the VBE
- Hit the Save diskette icon.
- Close the VBE.
- Go to Tools-Customize, and choose the Commands tab.
- Under Category, choose Macro, and on the right, click and drag "Paste Spec" up to your toolbar.
|
Test the code:
|
- Copy some text from the web.
- Hit the new toolbar button you just created.
|
Sample File:
|
No Attachment
|
Approved by Anne Troy
|
This entry has been viewed 119 times.
|
|