+ Reply to Thread
Results 1 to 2 of 2

Excel VBA code to read from Word documents in a folder and Print it to Excel

  1. #1
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2016
    Posts
    110

    Excel VBA code to read from Word documents in a folder and Print it to Excel

    Hello all,

    Firstly, I would like to inform you all that I'm new to forums and this is the 1st forum that I have joined.

    I've been working on Excel VBA (I'm new to this) to automate manual work done in Excel and have been successful mainly with the help of code that I have got from forums(like this one).

    Now, I'm facing another challenge and I would like your help. All these days, I worked only on Excel. Now, Word file(s) are involved. This is where I need your help.

    Here's what I have:
    * I have a folder (say, Employees).
    * The folder has 'n' no. of word files (say, each file has information about every employee).
    * Each file will have contents as follows:
    Name: Rooney
    Age: 27
    Country: England

    Here's what I would like to achieve:
    1) Take 1 file at a time and read the contents of the word file.
    2) Once you have read all the detials (like Name, Age and Country), print them into excel file under columns(Name, Age and Country).
    3) Repeat steps 1 and 2 for 'n' files in the folder
    4) Once you have processed all files, save the Excel sheet.

    Here's what I have tried:
    1) Open the folder where I have the files.
    2) Open the 1st word file

    Issue:
    * I'm not to read the contents of the word document. The macro gets stuck.

    P.S.: I'm sorry that I'm not able to provide the partial code that I have for the moment.

    Your inputs and help on this would be much appreciated.

    Many thanks,
    Vinod Krishna
    Last edited by Vinod Krishna.C; 06-11-2013 at 05:50 AM.

  2. #2
    Registered User
    Join Date
    12-02-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Excel VBA code to read from Word documents in a folder and Print it to Excel

    HI there
    Thanks for your sharing.I think it is a little bit for you to do that without a excel processing program.You can just add a powerful tool to help you with that.
    For me ,i am also the new user of excel.And i have purchased an excel program.You can have a try.Hope to help you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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