Re: Macro To "Paste Unformatted"...

In article <C18B33A2.B79A%rchampion@xxxxxxxxxxxxxxx>,
"Robert R. Champion" <rchampion@xxxxxxxxxxxxxxx> wrote:

I seldom paste formatted text; most of the time I have to Paste
Special-Unformatted (too bad there is not a Preference setting for that; if
there is, I can't find it!).

There isn't.

I also almost never paste styled text, so I replace the Paste command by
including something like this macro (my actual macro is rather more
complicated, but highly ideosyncratic) in an add-in:

Public Sub EditPaste()
'Paste Plain Text, if possible.
On Error GoTo ErrHandler
Selection.PasteSpecial Link:=False, _
Placement:=wdInLine, _
DisplayAsIcon:=False, _
DataType:=wdPasteText
ExitSub:
Exit Sub
ErrHandler:
Selection.Paste
Resume ExitSub
End Sub

I then add an item to the menu to paste formatted text for the very rate
cases that I might want to:

Public Sub EditPasteFormatted()
Selection.Paste
End Sub
.

Relevant Pages

  • Re: Caching?
    ... And regardless of why I changed the filename, ... when I deleted the file altogether, the macro would not finish. ... Filesearch just might return the old-name of a renamed file. ... Public Sub ImportFiles() ...
    (microsoft.public.excel.programming)
  • Re: Caching?
    ... << Not sure what you mean by "somehow, EXCEL remembers what files were ... got a FRESH COPY of the template with the macro in it and reran the macro. ... somehow reach outside the calling file. ... Public Sub ImportFiles() ...
    (microsoft.public.excel.programming)
  • Re: Caching?
    ... that it appears that you can run a macro, ... Dim dFileCount As Long ... Public Sub ImportFiles() ... Public sPath As String, sAppName As String, sFileName As ...
    (microsoft.public.excel.programming)
  • Re: Caching?
    ... I agree that a commented macro cannot matter, so I have to assume that, ... so I didn't think commenting it out would help, ... Public Sub ImportFiles() ... Public sPath As String, sAppName As String, sFileName As String, ...
    (microsoft.public.excel.programming)
  • Re: Caching?
    ... I assume that this was to be added to the macro with nothing taken out, ... Public Sub ImportFiles() ... Public sPath As String, sAppName As String, sFileName As String, sData ... ReDim Preserve arrFiles+ 1) ...
    (microsoft.public.excel.programming)