copy & paste macro doesn't work

Topic

New Reply

Office 2007:
This macro I use in Word is supposed to copy to the end of the line, 5 lines in succession, then cursor to the next line (if any).
Purpose-To put address info to the Office Clipboard, where I can easily paste into Excel cells.

Sub FiveLineCopy()
‘
‘ FiveLineCopy Macro
‘
‘
Selection.EndKey Unit:=wdLine, Extend:=wdExtend
Selection.Copy
Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.EndKey Unit:=wdLine, Extend:=wdExtend
Selection.Copy
Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.EndKey Unit:=wdLine, Extend:=wdExtend
Selection.Copy
Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.EndKey Unit:=wdLine, Extend:=wdExtend
Selection.Copy
Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.EndKey Unit:=wdLine, Extend:=wdExtend
Selection.Copy
Selection.MoveRight Unit:=wdCharacter, Count:=1
End Sub

Reply | Quote

Replies

What exactly goes wrong? When I run your code in Word 2002, it does put 5 items on the Office clipboard, and when I switch to Excel, these are available to be pasted.

Reply | Quote

I see the cursor flicker down the five lines, but nothing is copied. The clipboard is available and not full.

Reply | Quote

I hope that someone who has Word 2007 (I don’t) can help you.

Reply | Quote

It works perfectly for me under Office 2007 SP2.
I can watch it copy 5 lines to the clipboard, one after the other.

Reply | Quote

Could it be something about your document? Does the problem occur in all documents?

Reply | Quote

I’ve attached an example of a list where the macro doesn’t work. The problem seems to change every day. Today, it moves down but only copies the fifth line.

Reply | Quote

I’ve attached an example of a list where the macro doesn’t work. The problem seems to change every day. Today, it moves down but only copies the fifth line.

I can’t see anything wrong with this document.

I displayed the clipboard and cleared it
I placed the cursor immediately before the line “UO Office of Admissions”
I ran your macro and captured the attached screen shot, showing 5 lines on the clipboard.

Reply | Quote

Thanks for checking this out. The problem appears to be the clipboard itself, and I have posted about that separately.

Reply | Quote

Thanks for checking this out. The problem appears to be the clipboard itself, and I have posted about that separately.

I don’t know about the clipboard problem, but I did code something similar, to create a table, and I forgot to put the cursor at the beginning of the line after each carriage return. I don’t know the code but usually use the “record macro” command to provide the code and doctor it from there.

HTH.

Paul

Reply | Quote