I'm wondering if there's someone who would be kind enough to lend a hand. I have a folder, we'll call it "C:\TEMP". It contains subfolders for each month (ie: January, February). Inside each folder is a series of Word docs. There are 325 files spread across these twelve folders.
I need to bring the text out of all of these Word docs in to Excel, with a twist. I need information relative to each file as well. What I'm hoping for is something like this (including formatting hopefully):
[TABLE="width: 500"]
[tr][td][/td][td]A (Subfolder)
[/td][td]B (File Name w/o extension)
[/td][td]C (Text Body)
[/td][td]D
[/td][td]E
[/td][td]F
[/td][td]G
[/td][/tr][tr][td]1
[/td][td]January
[/td][td]Working Around Steam
[/td][td]Blah Blah Blah
[/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]2
[/td][td]March
[/td][td]Shoveling
[/td][td]Blah Blah Blah
[/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]3
[/td][td]December
[/td][td]Christmas Decorating
[/td][td]Blah Blah Blah
[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/TABLE]
This would save our company many, many man hours