Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I copy a word table into excel | New Users to Excel | |||
Copy filtered table to Word | Excel Worksheet Functions | |||
How do I copy a table from Excel to Word or a chart to Ppt in a ma | Excel Programming | |||
Q: copy/paste table from Word | Excel Discussion (Misc queries) | |||
Copy Word table to Excel | Excel Programming |