+ Reply to Thread
Results 1 to 3 of 3

Word VBA Split Text

  1. #1
    Forum Contributor
    Join Date
    05-24-2020
    Location
    London
    MS-Off Ver
    Office 365 pro
    Posts
    177

    Word VBA Split Text

    Der Experts,
    I have a VBA with which I want to divide a Word document into equal parts and save the individual parts in Word files in a separate folder.
    For this I have 2 input boxes. The one defines the folder, the other the maximum number of words that must be present in one of the Word documents to be saved.

    It works so far except for the number of words in each document. There are too few words there.

    Here is the VBA:
    Please Login or Register  to view this content.
    Maybe someone can help me with the script please.
    ANY OTHER SOLUTION IS MORE THAN WELCOME.

    Thank you very much.
    Last edited by CoSinus; 01-31-2023 at 10:06 AM.

  2. #2
    Forum Contributor
    Join Date
    05-24-2020
    Location
    London
    MS-Off Ver
    Office 365 pro
    Posts
    177

    Re: Word VBA Split Text

    Here is an improved Version. It still does not save the number of words specified in the input box. But it comes close.
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-24-2020
    Location
    London
    MS-Off Ver
    Office 365 pro
    Posts
    177

    Re: Word VBA Split Text

    I figured it out and improved the code:
    For all of you that have huge files to split. Here is a code with a delay of 4 seconds between saving each word document.
    This time period can be adjusted.
    Please Login or Register  to view this content.
    Here is the line that allows you to adjust the timer:

    Please Login or Register  to view this content.
    Just change the number to the desired seconds.

+ 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. Formula to split text on word boundaries
    By MollyD in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2020, 10:48 AM
  2. Replies: 4
    Last Post: 09-26-2019, 03:13 PM
  3. [SOLVED] How to Split a string and put each word in text box
    By MeSH16 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2015, 12:38 AM
  4. Having problem with text to column split on a particular word
    By alicia ch in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-01-2012, 12:29 PM
  5. Replies: 10
    Last Post: 10-24-2012, 04:02 AM
  6. Finding certain word in cell....then split text
    By Lynx2x in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-22-2012, 08:09 AM
  7. Split Text on word boundary
    By robertmee in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-26-2008, 10:45 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