Almost complete novice at VBA so small words please and bare with me.
I have been writing word documents for the past 3 months (approx 500) on safety legislation in my workplace.
After completing all of these (which need updating regularly) I have been asked to reference the word documents to state which legislation is relevent to each word document.
If possible what I need is for VBA to search a folder of word files for examples of text: eg. HOHOHO-1, HOHOHO-2 all the way to HOHOHO-600 (each word file contains around 5-6 random ones of these along with other information) and put them into a single spreadsheet. Each word file is named 01-file name, 02-file name etc to about 400. paste each file name into excel in row $a$ starting at a2, list the HOHOHO-XXX numbers down the left a$1$ and THEN to mark in the relevant cell which file name contains which HOHOHO-XXX numbers.
Word file '01-file name' contains, HOHOHO-1 HOHOHO-345, HOHOHO-567 and HOHOHO-789.
spreadsheet would like something like the one attached.
Any help is appreciated and would have me days of mucking about
Thanks in advance![ATTACH=CONFIG]51241[/ATTACH]