+ Reply to Thread
Results 1 to 4 of 4

Output excel data to text (or Word) files with column headers included

  1. #1
    Registered User
    Join Date
    09-17-2020
    Location
    Kingsville, TX
    MS-Off Ver
    2016
    Posts
    2

    Output excel data to text (or Word) files with column headers included

    Hello,

    I am very much a novice at VBAs or macros (or coding in general), but wanted to see if anyone here might be able to help me out. Not sure how easy or difficult what I want really is.

    Basically I have a spread sheet with with a bunch of names in column A (see attached), and then several more columns with questions they answered in an online form. The names of each question are the column headers and their responses fill out each row below. What I want is to be able to output each row of data to a text file (or Word doc would be even better if that is possible) and have it look like:


    Name: John
    Question 1: yes
    Question 2: 4
    Question 3: 3

    Name: Liz
    Question 1: no
    Question 2: 3
    Question 3: 1

    etc.

    Ideally each persons responses would be a different file (with their name as the file name), but this isn't the most important part. Even if everything was extracted to a single text file in the format I have listed above, that would save me a ton of time. Any help would be appreciated. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Output excel data to text (or Word) files with column headers included

    Please Login or Register  to view this content.
    Edit:
    Missed
    Ideally each persons responses would be a different file (with their name as the file name),
    Last edited by jindon; 09-28-2020 at 09:14 PM.

  3. #3
    Registered User
    Join Date
    09-17-2020
    Location
    Kingsville, TX
    MS-Off Ver
    2016
    Posts
    2

    Re: Output excel data to text (or Word) files with column headers included

    Thank you so much... this works perfectly!

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Output excel data to text (or Word) files with column headers included

    You are welcome.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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 output rows of data as separate text files ?
    By Dale Saukerson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2020, 05:22 PM
  2. Replies: 3
    Last Post: 08-28-2019, 08:45 AM
  3. [SOLVED] Move Data From One Column to Another based on column headers and Row Text
    By DerbysGal in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 02-10-2014, 07:21 AM
  4. Replies: 0
    Last Post: 11-26-2012, 05:51 PM
  5. Extract headers from multiple Word files and list them in Excel
    By Towanda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2012, 12:09 PM
  6. Compare 2 columns near equiv (one has text included) and output to new column
    By CNE5x in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2012, 01:24 PM
  7. control-M characters in text files output from Excel
    By embirath in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2006, 01:44 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