Discussion on:
View:
Show:
When you paste something into word a little clipboard appears it gives you options to keep the formating or not.
Great tip! (nice blog too). You can also redefine your ctrl-V key so that it always pastes unformatted, which is what I have done.
Doesn't work for me.
I get "Selection.PasteSpecial DataType:=wdPasteText" pasted into my document when I try to run your macro. What am I doing wrong?
I get "Selection.PasteSpecial DataType:=wdPasteText" pasted into my document when I try to run your macro. What am I doing wrong?
Very useful - note that the equivalent VBA in Powerpoint that works for me is:
ActiveWindow.Selection.TextRange.PasteSpecial DataType:=ppPasteText
You don't seem to be able to add it as a keyboard shortcut, but you can add it as a toolbar button.
ActiveWindow.Selection.TextRange.PasteSpecial DataType:=ppPasteText
You don't seem to be able to add it as a keyboard shortcut, but you can add it as a toolbar button.
I tried your VBA code and it didn't work. I'm using PPT 2003, if that makes a difference. I know very little about Macro's, but this seemed like a good time to learn. I first created a module in the VBA editor which looked like this
Sub NoFormatPaste()
ActiveWindow.Selection.TextRange.PasteSpecial DataType:=ppPasteTextSelection.PasteSpecial DataType:=ppPasteText
End Sub
I saved it. And then I copied the individual line of text from an excel document. In ppt, I clicked my newly made button (without keyboard shortcut) and nothing happened. No bug found. Simply nothing happened. Any idea what's going on here?
Sub NoFormatPaste()
ActiveWindow.Selection.TextRange.PasteSpecial DataType:=ppPasteTextSelection.PasteSpecial DataType:=ppPasteText
End Sub
I saved it. And then I copied the individual line of text from an excel document. In ppt, I clicked my newly made button (without keyboard shortcut) and nothing happened. No bug found. Simply nothing happened. Any idea what's going on here?
Great post!
For the very beginners I'd advice watching this video tutorial to complete the task:
http://www.myhowtoos.com/en/excel-howtoos/83-how-to-paste-as-unformatted-text-using-a-shortcut-in-ms-word
For the very beginners I'd advice watching this video tutorial to complete the task:
http://www.myhowtoos.com/en/excel-howtoos/83-how-to-paste-as-unformatted-text-using-a-shortcut-in-ms-word
That's an awful lot of work when you could just use Ctrl+Alt+V. I apologize in advance for any bubbles burst. 
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
