B
Bonsai Bill
I need to import a Word table, and its continuation, into Excel. The table is
tab delimited so cutting and pasting would be fine. I can clean it up
afterwards before using the data. In trying to impliment past postings on
this site I found that the table has vertically merged cells (generates error
5991). The other problem is that it is called "Table 6" but there are many
unnumbered tables in the document preceding it.
I can find tables because they have unique text in headings (e.g. Seq.).
Picking up proper code using the Word macro recorder to find table and then
put selected tables onto clipboard didn't work.
Could someone please provide me with sample code to find the tables, put
them onto the clipboard and paste them into Excel? I am using OfficeXP but
users may have later editions, including Office 2007.
All suggestions would be greatly appreciated!
tab delimited so cutting and pasting would be fine. I can clean it up
afterwards before using the data. In trying to impliment past postings on
this site I found that the table has vertically merged cells (generates error
5991). The other problem is that it is called "Table 6" but there are many
unnumbered tables in the document preceding it.
I can find tables because they have unique text in headings (e.g. Seq.).
Picking up proper code using the Word macro recorder to find table and then
put selected tables onto clipboard didn't work.
Could someone please provide me with sample code to find the tables, put
them onto the clipboard and paste them into Excel? I am using OfficeXP but
users may have later editions, including Office 2007.
All suggestions would be greatly appreciated!