ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy from word table (https://www.excelbanter.com/excel-programming/367634-copy-word-table.html)

RRodrigues

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

Art H

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."



All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com