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
Bookmarks