Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 05-23-2014, 03:12 AM
chinchee chinchee is offline Copy data from Word into Excel Windows 7 64bit Copy data from Word into Excel Office 2010 64bit
Novice
Copy data from Word into Excel
 
Join Date: May 2014
Posts: 10
chinchee is on a distinguished road
Default

Hi macropod,

I think I have answered you question?

How is the code to recognize the table?
Like I said - I was just planning on using a really crude macro something like the following:

Sub Macro1()
'
' Macro1 Macro
'
'
Selection.MoveDown Unit:=wdLine, Count:=4
Selection.MoveUp Unit:=wdLine, Count:=1
Selection.MoveRight Unit:=wdCharacter, Count:=3
Selection.MoveLeft Unit:=wdCharacter, Count:=1
Selection.MoveRight Unit:=wdCharacter, Count:=19, Extend:=wdExtend
Selection.Copy
End Sub

VBA can find tables easily enough, but how would it know then it's found the correct table? And, given that there's more than one table in the document, are the data in every table, or just one/some?
As I said, the datas are in exact "location" for every document, so I think the above macro should be alright - but I do agree with you that it is very crude

I must admit that I am a begineer to VBA, I am still trying to find my way around. Please bear with me if I sound like a total idiot.
Reply With Quote
 

Tags
copy/paste, multiple files, words



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Excel data into an existing Word Table JJG Word 1 12-18-2013 05:41 PM
How to Copy data from Outlook mail and Paste it in a Excel sheet? padhu1989 Outlook 0 09-11-2012 04:07 AM
how to copy all ms word tables into excel rehan129 Word 0 01-28-2012 10:17 AM
Copy data from Word into Excel How to copy automatically data from Excel file to Word file? fuchsd Word 6 10-25-2011 05:52 AM
Copy all comments & cell contents (i.e. data) to word? IanM Excel 0 07-03-2010 11:14 PM

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft