Thanks Paul,

I will try and get back to you.

Do what ever you can, please do not go out of the way.

Where is the updated 'Main' sub.

"I've also updated the 'Main' sub to handle documents that may have 0 and >1 TablesOfContents. Finally, contrary to what I had expected to happen, the code isn't deleting the tables in the source document. It will do so if you change:"

Formatting is not necessary not required.
"retaining the formatting gets complicated"


I need only the tables only. dont bother about moving it to excel, I will request it another time. I will work on all the 500 or so document first with what code I have.
"On reviewing the code I also found that (aside from the fact that it moves the tables to a new Word document instead of to an Excel workbook) a number of variables weren't defined and the code copies the paragraph following the table to the new document as well. Is that what you wanted?"


All the best
FLDS