Importing data from an MS Excel table embedded in MS Word

[Erdal]

Hi everybody,

I have nearly 5,200 single page MS Word files which have a single MS excel table embedded in them. All the embedded excel tables have exactly the same format for the same parameters. Now the problem is, I need to take the data back to excel from MS word for further data search. As you suppose, the original excel files are not available. If I had a couple of files, it wouldn't be a problem by double clicking the table in word, entering the table as an excel object and then copy/paste to Excel but to do the same work for 5,200 times seems to be tedious. Is there an automated way to repeat this job for me?

Thanks in advance,

Regards.

 

[Trevor G]

Welcome to the Forum,

So are you wanting to run something from Excel or from Word?

In Word you can record Macros which will give you the basis of the code you need then it just needs to loop through all the documents.

Suggestion:
Open a blank Word Document then Select to Record a New Macro in Word. Then Open a Document where you need the table and do what you would normally do, then once completed stop recording. Then look at the code and if it helps post back and someone will help you.