This needs Visual Basic for Word, I'm afraid.
It's easiest to have all the files with a fixed filename in a folder, say app001.doc through app999.doc. Then you would have to write a module (macro) which opened each file in succession, and saved the contents to a text file, say app001.txt through app999.txt. When ready the macro should create something like appall.txt, read all those text files, and append them to appall (that's old time Basic, in fact).
An alternative might be to have the macro Insert all forms behind each other in one large document and do one Save data only for all together. I don't know if it works, but it's easy to try from the screen.
Working with randomly named files should necessitate the use a filesystem-object, which complicates matters somewhat. With filenames following a pattern it's easier to open them.
Hope this helps.
I am trying to make an database of members for a racing organazation.
Each member has a word document which contains the membership form filled out with Word's Form feature. I know you can do Options > Save > Save Form data only, then save for each file, but i'd like to automate the process and save only form data for all of the documents at once.
Secondly, I'd like to import them into an excel spreadsheet. I've used the data import feature, but once again, the process has to be repeated for every single file. I cannot select more than one. Again, I'd like to autmate it. How?
Better yet would be a method to take all the .doc file's form data straight into excel without going to the middle .txt file.
Thanks for your help,