Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing / Linking Dynamic Data or ASP Tables into Excel ? | Excel Discussion (Misc queries) | |||
Importing Tables from Word to Excel | Excel Discussion (Misc queries) | |||
Importing from excel to word | Excel Discussion (Misc queries) | |||
Importing Tables from Access into Excel using Macros or VBA | Excel Discussion (Misc queries) | |||
Importing Access tables to an Excel worksheet. | Excel Programming |