Solved: Exporting Data from Word Forms to Excel

[mjwinxsky]

Hi,

I am totally new to Automation. I got to this forum because of a task given to me by my boss. She wanted me to extract data from word files to an excel sheet and I have no idea how to do it. He told me to do it manually but that is absurd since there are 200 forms. The word forms are in a single folder. Not all the data in Word forms need to be transferred but only few of them. Basically, here are the data that need to be transferred to the spreadsheet.

Ticket Num
Open Date
INC Type
Status
Resolved Date
Closed Date
Priority
Reporter Name
Description
Cat Lvl 1
Cat Lvl 2
Name Of H/S
Assignee
Solution

I am not sure if this can be done but I would really appreciate if anyone can help me do it. I have attached here the sample Word form as well as the spreadsheet with the data of the desired result.

Thanks in Advance.

Regards,
MJ

[mjwinxsky]

I forgot to mention, I am using Office 2010.

[macropod]

There have been numerous threads here discussing the extraction of Word 'form' data to Excel. See, for example: http://www.vbaexpress.com/forum/showthread.php?t=40406
See also: http://social.technet.microsoft.com/Forums/en-US/word/thread/f9f3aa33-8ee9-4e23-8c13-79f1cebdb446

[mjwinxsky]

Hi macropod,

Thanks for the response. Actually, the script that worked for me was the script posted by Stephen_ in the thread of pdalton (Extract data from Word Form responses to Excel Spreadsheet). I cannot post the link because of the forum rule that I should at least have 5 posts first. Anyway, I really appreciate your time checking on this.

MJ

[mjwinxsky]

Admin,

please tag this thread as resolved. thanks.

mj

[macropod]

mj: Please mark the thread as solved. You do this via the 'Thread Tools' dropdown. The Admins don't do it - they probably won't even look at the thread.