Extract Data from a table in word documents

[mmf]

Hi. I was trying to do this, but definitely I need some help to manipulate the data from word, and probably to adjust the code in a less Flintstone way.

I have in a spreadsheet sheet1 a date (month and year) which I place manually
According to that date, I have to open a set of word documents (which are saved with a name convention for each month). Each document has a table with some information for a specific item. In this case B5 that I would like to retrieve and place in the excel sheet just for that particular month.

For example for Feb 2008 there are just three files that need to be opened and an extract the values for B5 and place in the table in the excel sheet.


I manage to extract the doc file according to the month and year, and also in a very Flintstone way I manage to identify the file to open, but there I just stop, because I run out of ideas of how to open each and extract the data and then populate the excel sheet

I would really appreciate any help,

[mmf]

This is the bit of code that I made up to now.
which load the doc files in the directory year into the excel sheet.
I will continuos to try, but if any body came with a better way to do it. I would appreaciate it.
Bye pals

Please Login or Register  to view this content.

[mmf]

hi I manage with the help of other threats to put togheter this code, which works sometimes

I wonder if someboy can help to:
1. Open properly the word application (if it needed if there is any way to extract the data without open the word file will be better)
2. How to select the whole table in word, at the moment i am getting only the first cell
thanks

Please Login or Register  to view this content.

[mmf]

Hi folks, sorry to annoy you with this word stuff

Every time that I re run the code I get an alert telling me that the word file is already open and still used by me, so is asking me in would like to open it as only read and so on.
Does anybody knows how to avoid the alerts from word?

regards
MMF