I have a problem similar to this: vbaexpress.com/forum/showthread.php?40406-Extracting-Word-form-Data-and-exporting-to-Excel-spreadsheet (had to remove hyperlink since I'm a new user)
I created a template (see attached) in Word with several legacy form fields. Each form field has a unique reference name which matches a column on a spreadsheet. These forms will be completed by other people and then sent to me where I need to get the data onto the spreadsheet, under the corresponding names. The forms will be stored in one folder and sent to me sporadically, so I'll need to update the spreadsheet over time and have new entries populate on a new row. I've tried to alter a few solutions to fit my needs but I'm afraid I'm not familiar enough with VBA to make it work fully. Any help is much appreciated and I hope to use this to help me better understand VBA. Thanks!
Reply With Quote