View Single Post
 
Old 10-09-2014, 06:26 AM
spiderman1369 spiderman1369 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2014
Posts: 2
spiderman1369 is on a distinguished road
Default Loop through files and Copy Table Row and Paste into Different Document

I have a folder with about 300 Word 2010 documents and each has a table in the document. The naming convention for the files is 3-ABC-DE-####.docx (where #### = numbers). I also have a file in the same directory named 3-ABC-FGH-001.docx (this is a table of contents file).

I need to copy the same specific row from the table in each of the 300 documents and sequentially paste each row into the Table of Contents file. Thus having 300 rows in the TOCs file.

Thus, loop through all 300 files, copy the specific row, and dump it into the TOC file.

Is it possible to do this with some vba code? Any sugguestions?
Reply With Quote