-
Help to paste without table formatting (learning, the hard way)
Hello,
Continuing my haphazard intro to VBA, I was able to write a little brutish sub to copy the content of a table's cell from a document in a file, and paste it into another document. But I can't seem to figure out how to paste it as just text, without the table formatting. I am hoping someone could help with this, and if not asking too much, if they could show me if there was a more efficient way of doing this. Thanks so much!
Sub CopyTable()
Dim Osource As Document
Dim Otarget As Document
Set Otarget = ActiveDocument
Set Osource = Documents.Open("C:\documentlocation.docx")
Osource.Tables(2).Cell(2, 1).Range.Copy
Otarget.Range.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