+ Reply to Thread
Results 1 to 4 of 4

Excel if new row is created, auto-populate columns in word doc and create new word doc

  1. #1
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    Excel if new row is created, auto-populate columns in word doc and create new word doc

    Hi all,

    I have an idea in mind that I'm trying to figure out if it will work. Would the following be possible?

    If I have 3 columns in use

    A. Date
    B. Name
    C. Age

    If one row is fully filled out from A to C, soon as it is saved, I need it to automatically create new word doc, place the new row data into the word document and save it as a new file inside the folder. If another row is filled out, same again, create new word doc, insert new data into the file and save it into the folder.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,770

    Re: Excel if new row is created, auto-populate columns in word doc and create new word doc

    Give this a go...
    On entering info into specific row columns A to C...If all columns of that row is populated then the code runs...
    Please Login or Register  to view this content.
    Last edited by sintek; 07-30-2019 at 07:12 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    Re: Excel if new row is created, auto-populate columns in word doc and create new word doc

    Hi, thanks for putting your time and effort into this.
    I have an error with this, comes up with compile error: User-defined type not defined. After I have typed the date in column A moving on to Col B.

    EDIT

    I have modified this:
    Please Login or Register  to view this content.
    Also, how can I start the proccess of saving when hitting CTRL + S or just by simply clicking save?

    Thank you
    Last edited by Eduards; 07-30-2019 at 08:22 AM.

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,255

    Re: Excel if new row is created, auto-populate columns in word doc and create new word doc

    Possibly as a Worksheet Change function...
    Please Login or Register  to view this content.

+ 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. Macro to auto-populate word template with bookmarks
    By DellRussellHWS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2014, 04:33 PM
  2. Replies: 1
    Last Post: 07-02-2014, 09:45 AM
  3. VBA Code to open word and auto populate labels from excel?
    By jtemp57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 03:56 AM
  4. Replies: 1
    Last Post: 04-26-2012, 06:42 AM
  5. In Word 2007, how do I work within a form created in Word 2003
    By LilyMarie in forum Word Formatting & General
    Replies: 1
    Last Post: 03-05-2009, 04:26 AM
  6. Import cells from excel into word and create multiple word docs
    By scdaddy7269 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2006, 03:03 PM

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