-
Paste each entry from Clipboard into new document
Can anyone help me on this?
Story is, I?ve got like 50 docs in microsoft word copying over from Adobe. Sometimes there?s one document on the adobe page ? sometimes 3 documents on the one adobe page. What I can do is copy the text of each document onto my clipboard. Then paste each entry onto a new document. Thus flying through the project and I?ll get it done in an hour.
Does anyone know if there?s a command to paste an entry from the clipboard?
Does anyone know if there?s a command to delete the top entry from the clipboard?
I did it manually for a wee bit to get a feel for the code and see if I could automate it from there but it doesn?t seem to be pasting or deleting the entry.
I need to
- paste the entry
- delete the entry
- new document
- paste the entry
- delete the entry
blah blah blah until the clipboard is finished?
As you can see from here (even though I did delete the entry each time, it?s not showing up on the code at all).
There might not even be a command to paste from clipboard and/or delete top entry. Just thought I?d ask and see if you could help?
Sub aaaTest()
WordBasic.EditOfficeClipboard
Selection.Paste
Documents.Add DocumentType:=wdNewBlankDocument
WordBasic.EditOfficeClipboard
Selection.Paste
Documents.Add DocumentType:=wdNewBlankDocument
WordBasic.EditOfficeClipboard
Selection.Paste
Documents.Add DocumentType:=wdNewBlankDocument
WordBasic.EditOfficeClipboard
Selection.Paste
Documents.Add DocumentType:=wdNewBlankDocument
WordBasic.EditOfficeClipboard
Selection.Paste
Documents.Add DocumentType:=wdNewBlankDocument
WordBasic.EditOfficeClipboard
Selection.Paste
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules