LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Importing Word tables into Excel

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
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
Importing / Linking Dynamic Data or ASP Tables into Excel ? Dan Thompson Excel Discussion (Misc queries) 0 November 24th 09 06:19 PM
Importing Tables from Word to Excel Will Payton Excel Discussion (Misc queries) 3 July 8th 08 05:18 PM
Importing from excel to word Kenike Excel Discussion (Misc queries) 2 November 30th 07 08:10 PM
Importing Tables from Access into Excel using Macros or VBA CLamar Excel Discussion (Misc queries) 4 May 23rd 06 09:23 PM
Importing Access tables to an Excel worksheet. Narwe Excel Programming 0 September 13th 04 05:35 AM


All times are GMT +1. The time now is 03:09 PM.

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"