I currently have numerous reports that I pull information into excel. An example of the forms is shown below. Is there a way to pull specific information, i.e. only the "Project Name" and "Sales Representative", into excel? We can assume that the file name to the word document is known, but vary depending on the report. I am not very good with VBA, but I am hoping someone can help me out. Any suggestions are appreciated.
Project Name: THIS IS A SAMPLE PROJECT
Project Sub-Name:
Project Location: NEW YORK, NY
Quote Name:
Through Addenda Number: 0
Bid Date: 01/01/2001
Consultant / Specifier: SAMPLE CONSULTANT
Contractor / Installer: SAMPLE CONTRACTOR
Sales Representative: JOHN SAMPLE
Project Name: THIS IS A SAMPLE PROJECT
Project Sub-Name:
Project Location: NEW YORK, NY
Quote Name:
Through Addenda Number: 0
Bid Date: 01/01/2001
Consultant / Specifier: SAMPLE CONSULTANT
Contractor / Installer: SAMPLE CONTRACTOR
Sales Representative: JOHN SAMPLE
