VBA Code to take data from a table in word document and place it in a summary table

VBLearner · #1 03-09-2014, 06:28 PM

This is in the same document. I tried to record the code, but I keep getting an error saying "value out of range". I essentially want to take a revision date from a certain part of a table and copy and paste it to a summary table in the same document.

This is what I tried:

Code:

Sub Copy_To_Index()
'
' Copy_To_Index Macro
'
'
    Selection.MoveLeft Unit:=wdCharacter, Count:=16, Extend:=wdExtend
    Selection.Copy
    ActiveWindow.ActivePane.VerticalPercentScrolled = -40
    Selection.MoveUp Unit:=wdLine, Count:=165
    Selection.MoveDown Unit:=wdLine, Count:=4
    Selection.MoveUp Unit:=wdLine, Count:=1
    Selection.MoveRight Unit:=wdCharacter, Count:=3
    Selection.PasteAndFormat (wdFormatPlainText)
End Sub

Thanks for any help!

macropod · #2 03-09-2014, 08:42 PM

Evidently your document has more than one table. Which table in the document are you:
• copying from
• copying to?
For each of those tables, what is the cell address you're:
• copying from
• copying to?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert table in document - automatically updates second table in summary?	Mechanic	Word	2	08-01-2012 09:44 PM
Place table over image as background	vavs	Outlook	1	08-15-2011 09:32 AM
adding table to a particular place	hklein	Word VBA	2	07-25-2011 01:45 AM
How do I dynamically update data in a Word Document from a database table	RSchmidt	Word	1	07-14-2011 04:27 PM
Excel data to Word table	Jaymond Flurrie	Word VBA	2	02-27-2011 07:42 PM