I am new to writing VBA macros and trying to gain proficiency, while trying to get work accomplished at the same time .
I now use VBA to open a number of text files, one at a time in Word, complete modifications, and then resave in advance of use elsewhere. What I would like to do is further automate by having the a VBA macro retreive the text file names from a pre-existing list from an Excel file and use that data to identify and text files (in WORD).
In summary, my vision is to:
1) Have VBA identify all of the required text files in a given sub-directory and transfer those names to an EXCEL worksheet (covered).
2) Have WORD draw from the list to individually open each text file (not covered) before modifying and saving (covered), and then moving on to the next file in the list.
I haven't yet found examples to match my requirement.
Thank you in advance if you can help.
I now use VBA to open a number of text files, one at a time in Word, complete modifications, and then resave in advance of use elsewhere. What I would like to do is further automate by having the a VBA macro retreive the text file names from a pre-existing list from an Excel file and use that data to identify and text files (in WORD).
In summary, my vision is to:
1) Have VBA identify all of the required text files in a given sub-directory and transfer those names to an EXCEL worksheet (covered).
2) Have WORD draw from the list to individually open each text file (not covered) before modifying and saving (covered), and then moving on to the next file in the list.
I haven't yet found examples to match my requirement.
Thank you in advance if you can help.
