+ Reply to Thread
Results 1 to 3 of 3

Split a single word document into multiple word documents

  1. #1
    Registered User
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2003
    Posts
    24

    Split a single word document into multiple word documents

    I have a word documents containing images which sizes about 10 MB to 15 MB. I wanted to split these documents into mutliple documents each of size not more than 2 MB. Manually doing this is time taking, I'm trying to develop a user-form in excel which prompts for the file that needs to be split. Once I select the file and submit the command button, excel should should split the document.

    Can any one help me out with Excel VBA code that splits a single document into multiple word documents (each of the document should be less than or equal to 2MB).

    - Captain Cool

  2. #2
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: Split a single word document into multiple word documents

    Not sure about your original request based on size but below is an alternative if no other found:

    If you can place xxx after each image then you can open the word doc with the images, press F11 to open vb editor and run the macro below in the worksheet.

    xxx - represents the string to seperate each image and can be changed in the top of the sub.
    Images - is the name each file with start with followed by 001 and higher based on the number of files.
    You will also get a Message Box count of the number of files with the option to proceed or not.

    Please Login or Register  to view this content.


    Shelton A.
    If Helpful, Add Reputaion!

  3. #3
    Registered User
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Split a single word document into multiple word documents

    Again thanks for your code. But my intention is to split the documents into files not more than 2MB. :'(

    - Captain Cool

+ 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. Batch Compile 100+ multiple word documents into a single word document
    By JamesFrames8 in forum Word Formatting & General
    Replies: 4
    Last Post: 04-03-2014, 08:49 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

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