+ Reply to Thread
Results 1 to 5 of 5

Batch Compile 100+ multiple word documents into a single word document

  1. #1
    JamesFrames8
    Guest

    Question Batch Compile 100+ multiple word documents into a single word document

    I have 100+ documents that I want to compile into a single document. I plan on chopping them up to extract key bits of information - does anyone know a macro that can accomplish this task? I know the long part will be deleting a bunch of stuff, but I am okay with that, as long as I don't have to open, click, copy, paste 100+ times (i.e. I would rather, highlight, delete, and be left with just the information I need)

    A note - Headers and Footers are included in each of these documents, if there is some way to transfer the headers into the body of the massed document, that would be nice too. In other words, I don't need to keep the headers as headers, ideally, they would be dropped into the document as well.

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,667

    Re: Batch Compile 100+ multiple word documents into a single word document

    If you need to "extract key bits of information" from the documents you would do far better to extract it from each document as it is rather than by combining them, which is a lot of extra effort, especially where headers & footers are concerned, beforehand. I have already given you the code you'd need for bulk processing of the documents - all you need do is change the Find/Replace parts to do the data extraction rather than just updating conent.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    JamesFrames8
    Guest

    Re: Batch Compile 100+ multiple word documents into a single word document

    Sounds good - in what portion do I change the Find/Replace parts to be data extraction? - the key bits of information is different between the 100+ Documents, does that matter? They are also in tables

  4. #4
    JamesFrames8
    Guest

    Re: Batch Compile 100+ multiple word documents into a single word document

    I tried posting the macro here but it came out all wrong

  5. #5
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,667

    Re: Batch Compile 100+ multiple word documents into a single word document

    To send content to another file, you'd need to add code to reference that file. I can't tell you how to do that yet, because I don't know what type of file you want the output to go to (eg Word document, Excel workbook), though your reference to header preservation suggests a Word document. The most obvious place to make any changes for the actual extraction would be in the 'RngFndRep' sub. As yet, I can't advise what those changes should be because: a) I don't know what you want to extract; or b) where you want to extract it to within the output file (e.g. if to a table, what the table's layout should be, whether you want a separate table for each file, and so on).

    When posting code, you should use the code tags to preserve the formatting - they're on the 'Go Advanced' tab.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 29
    Last Post: 05-07-2019, 10:24 PM
  2. Create Multiple pages in Single word document
    By SathishKumar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2013, 01:12 PM
  3. [SOLVED] VBA word (2003) codes to check if a table fits in a single page of the word document
    By samkumar in forum Word Programming / VBA / Macros
    Replies: 7
    Last Post: 08-27-2012, 09:35 AM
  4. [SOLVED] Separate pages from one main word document to multiple documents
    By bonny24tycoon in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2012, 06:53 PM
  5. Replies: 2
    Last Post: 11-09-2007, 07:54 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1