Solved

Macro that will Select the contents of a cell in a Word Table and Paste it at the end of the Document

Posted on 2009-04-11
4
185 Views
Last Modified: 2013-11-25
I need help writing a macro that will select and copy the contents of the 2nd cell in Row 2 of the 3rd Table in my active document and paste them at the end of the document.
Thanks for your help in anticipation.
0
Comment
Question by:FaheemAhmadGul
  • 2
  • 2
4 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 24121516
This will copy the text from the cell to the end of the document.
Sub CopyCellText()
    Dim tbl As Word.Table
    Dim strText As String
    
    Set tbl = ActiveDocument.Tables(3)
    strText = GetCellText(tbl.Cell(2, 2))
    ActiveDocument.Bookmarks("\EndOfDoc").Range.Text = strText
End Sub
 
Function GetCellText(cel As Word.Cell) As String
    Dim rng As Range
    
    Set rng = cel.Range
    rng.MoveEnd wdCharacter, -1 'drop cell format character
    GetCellText = Trim$(rng.Text)
End Function

Open in new window

0
 

Author Comment

by:FaheemAhmadGul
ID: 24121598
Many thanks for your help with my question. The above code works but the only thing is that when the contents of the relevant cell are pasted at the end of the document, they loose formatting they had in the source cell.
I would be grateful if you could modify the code so that the formatting is not lost in the process.
As this  involves some extra work, I am increasing the points for this problem  to 500.
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 24121810
My apologies. You did say copy and paste.
Sub CopyCellText()
    Dim tbl As Table
    Dim strText As String
    Dim rng As Range
 
    Set tbl = ActiveDocument.Tables(3)
    Set rng = tbl.Cell(2, 2).Range
    rng.MoveEnd wdCharacter, -1  'drop cell format character
    rng.Copy
    ActiveDocument.Bookmarks("\EndOfDoc").Range.Paste
End Sub

Open in new window

0
 

Author Closing Comment

by:FaheemAhmadGul
ID: 31569152
This worked perfectly. Many thanks. Regards,  Faheem
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now