Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Copy from word table

Hi,

I need a code to copy the information from cells in a Word table, to Excel.

I don't know if it helps, but the cells have bookmarks.

Is it possible?

Thanks
Ricardo Rodrigues
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Copy from word table

Use something like:

ActiveDocument.Tables(x).Cell(y, z).Select

where x is table number, y is row number of table, and z is column
number of table. Be aware that, for a non-empty Word cell, the
selection contains the "cell terminator." I just remove the last two
characters. You could also use the statement:

Selection.MoveLeft unit:=wdCharacter, Count:=1, Extend:=True

to get rid of the "cell terminator."

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy a word table into excel KF New Users to Excel 2 November 13th 08 03:46 AM
Copy filtered table to Word s0200897 Excel Worksheet Functions 0 May 3rd 07 04:05 AM
How do I copy a table from Excel to Word or a chart to Ppt in a ma Linda Vincent Excel Programming 0 November 30th 05 06:00 PM
Q: copy/paste table from Word JIM.H. Excel Discussion (Misc queries) 0 November 5th 05 04:57 PM
Copy Word table to Excel Nelson[_3_] Excel Programming 0 July 21st 03 06:54 PM


All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"