Re: Macro for Paste Special Unformatted Text

Hi LC,

Because that command will only bring up the Paste Special window, from which
you then have to select the formatting option you want and click OK.

But if you want to avoid macros, at least it does the job half way... ;-)

(I use it so often I couldn't afford to do that.)

Clive
=====

On 24/12/07 6:44 AM, in article
3da44c37-a630-4627-b6f0-8374d44144f8@xxxxxxxxxxxxxxxxxxxxxxxxxxx,
"little_creature" <litttle.creature.inc@xxxxxxxxx> wrote:

Hi,
maybe I have missed something but why do you need macro? why not to
simply assign a shortcut to pasteSpecial command? This works quite OK
for me and the advantage is that I do not unnecessarily put macros to
files, which I would be a bit careful if you share files with other
people.

On Dec 23, 3:27 am, Daiya Mitchell <daiyaNOS...@xxxxxxxxxxxxxxxx>
wrote:
Hi Julie,

Couple issues. If you recorded a Paste Unformatted Macro, it comes out
wrong. The recorder is broken for things involving Paste Special.

The macro you post should be fine, but I'm guessing the line break is in
the wrong place. You see where there is an underscore: _ ? Really the
underscore means "this underscore of _ should not exist and this should
all be one line." So try using the VBA editor to type all that as a
single line, and let it add an underscore if it needs to. In addition,
copying stuff from the web might include a line break that isn't the
same as the line break the VBA editor would use. I'd bet money that is
the problem. Some judicious backspacing should fix it.

Also, you can see here for a functional macro and instructions on fixing
errors.http://word.mvps.org/Mac/PasteText.html
(the one you have might be a little better, but that one has never
failed me)http://word.mvps.org/Mac/InstallMacro.html

The keyboard shortcut issue---the keyboard shortcut is not hard-coded as
part of the macro. You might need to re-assign it to a new macro.

While macros are not included in Word 2008, the AppleScript support is
better. For a home user, substituting AppleScript for Macros might be
just as efficient, once set up.

Daiya

Julie27 wrote:
I'm copying and pasting a lot of emails into one Word document. To
save steps, I created a macro to paste special unformatted text, but
it's not working right. It's pasting but not in unformatted text
form. My macro is:

Sub PasteUnformattedText()
'
' PasteUnformattedText Macro
' Macro recorded 12/22/07 by Baird Julianne
'
Selection.PasteAndFormat (wdPasteDefault)
End Sub

I searched these discussion threads and found this macro for the same
action

Selection.PasteSpecial Link:=False, DataType:=wdPasteText,
Placement:= _
wdInLine, DisplayAsIcon:=False

I copy and pasted those lines over my Macro commands but received an
error message.

Why isn't this working? I will admit I'm not very swift at creating
Macros.

Julie



.

Relevant Pages

  • Re: Macro recording in Access?
    ... > Stargate, as an example, you can build a command button that runs a macro. ... in Access without that recorder. ... thought Excel Vb was hard! ...
    (microsoft.public.access.gettingstarted)
  • Re: a bug in Words Underline, Italic and Bold commands
    ... what Word did when you ran some command from the user ... Though WordBasic as a macro language is dead, ... But even if the macro recorder produces some VBA code, ...
    (microsoft.public.word.vba.general)
  • Re: a bug in Words Underline, Italic and Bold commands
    ... what Word did when you ran some command from the user ... Though WordBasic as a macro language is dead, ... But even if the macro recorder produces some VBA code, ...
    (microsoft.public.word.application.errors)
  • Re: command to import a file into excel
    ... Sorry, if you want to import it into an existing document, turn on the macro ... recorder while you manually do ... the variable fName or whatever variable holds the fully qualified name of ... > click that command button, a common dolog box opens and i select a text ...
    (microsoft.public.excel.programming)
  • Re: huffman encoder
    ... All identifiers starting with an underscore followed by an upper case letter are reserved for the implementation. ... It's a macro name. ... A member of an enumeration is called an enumeration constant. ...
    (comp.lang.c)