PDA

View Full Version : Solved: Import Word Table & text into Excel



karlos
06-05-2007, 08:10 AM
Hope someone can help, very new to the world of VBA but willing to learn.

I have a word documents with 1 to 160 sections/pages with identical layouts apart from the data. The document has several tables in it of which I'm only interested in one which has varying number of rows and 4 columns.

I want the data in the table to be in the same fomat when copied to excel. Also I would like to gather some text from the document which again is in identical places on each section/page. The text required is preceded with the same title and separated by tab.

I should add that each section is a page ie section 1 is page 1 section 2 is page 2 and so on.

I would like to be able to transfer the bits I want to an excel sheet.

Attached is a brief doc of what I have ish, and what I would like in excel.

normal cut paste does the trick but takes ages so a VBA routine would be great if any one can oblige please. Tried importing via delimited text files but it gets really messy and then ages re jigging the data.

Can any one assist please.

karlos
02-19-2008, 10:26 AM
Is the above really difficult to do or so simple that its not worth bothering with? Either way its got me really confused. Any chance someone can assist?