+ Reply to Thread
Results 1 to 4 of 4

Creating Word Documents with Data from Excel

  1. #1
    Registered User
    Join Date
    04-17-2023
    Location
    United Kingdom
    MS-Off Ver
    2016
    Posts
    5

    Creating Word Documents with Data from Excel

    I am wondering if it is possible to create word documents from data within excel.

    Essentially, I work with spreadsheets which track people's sign in and sign out times. I start off by sorting them per person and then copy and paste the data for one person at a time in to a word document to send to the correct manager. As you can imagine, it is a very lengthy and manual process. It looks like it might be possible to automate this process by running a macro, is this the case? If so, do you have any advice on how to get this set up? This is my first time looking at VBA and I would be very grateful for any support.

    Example of Raw Data:

    Name Time In Time Out
    John Doe 06/04/2023 09:10 06/04/2023 10:54
    Jane Doe 06/04/2023 07:54 06/04/2023 12:31
    Adam Person 06/04/2023 08:15 06/04/2023 13:27
    John Doe 07/04/2023 07:49 07/04/2023 12:02
    Jane Doe 07/04/2023 08:17 07/04/2023 11:54
    Adam Person 07/04/2023 11:15 07/04/2023 15:33
    John Doe 08/04/2023 08:01 08/04/2023 12:36
    Jane Doe 08/04/2023 11:19 08/04/2023 17:22
    Adam Person 08/04/2023 07:56 08/04/2023 12:03

    Example of Completed Data:

    Name Time In Time Out
    John Doe 06/04/2023 09:10 06/04/2023 10:54
    John Doe 07/04/2023 07:49 07/04/2023 12:02
    John Doe 08/04/2023 08:01 08/04/2023 12:36
    Jane Doe 06/04/2023 07:54 06/04/2023 12:31
    Jane Doe 07/04/2023 08:17 07/04/2023 11:54
    Jane Doe 08/04/2023 11:19 08/04/2023 17:22
    Adam Person 06/04/2023 08:15 06/04/2023 13:27
    Adam Person 07/04/2023 11:15 07/04/2023 15:33
    Adam Person 08/04/2023 07:56 08/04/2023 12:03
    Last edited by ProcessG; 04-17-2023 at 04:33 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Creating Word Documents with Data from Excel

    try, in column A-B-C

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-17-2023
    Location
    United Kingdom
    MS-Off Ver
    2016
    Posts
    5

    Re: Creating Word Documents with Data from Excel

    Thank you for this. It is throwing up the error:

    Compile error:

    User-defined type not defined

  4. #4
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Creating Word Documents with Data from Excel

    in the VBA editor click Tools->References scroll to the "Microsoft Office xx.x Object Library" then check the checkbox next to it then click ok

    edit: check also "Microsoft Word xx.x Object Library"
    Last edited by k1dr0ck; 04-19-2023 at 11:26 PM.

+ 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. Extracting data from multiple Word documents into Excel.
    By X82 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2019, 05:42 PM
  2. VBA Transfer Data From Excel to Word and Keep Bookmarks in Word Documents
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2015, 05:37 AM
  3. [SOLVED] Export Excel Data to Seperate word documents
    By Simon.xlsx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2015, 01:28 PM
  4. Save as and creating loop for more word documents
    By JP2511 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2014, 10:37 AM
  5. Save as and creating loop for more word documents
    By JP2511 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2014, 09:05 AM
  6. [SOLVED] Macro is creating two word documents
    By ERaasio in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-03-2014, 01:27 PM
  7. Getting data into Excel worksheet from Word Documents??
    By Flabbergaster in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-06-2012, 06:07 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