Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-09-2014, 06:28 PM
VBLearner VBLearner is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Mar 2014
Posts: 1
VBLearner is on a distinguished road
Default VBA Code to take data from a table in word document and place it in a summary table

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!
Reply With Quote
  #2  
Old 03-09-2014, 08:42 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,660
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 04:04 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft