Using Office XP and Access 07. Access db runs script to open a word doc based off access table paths and for each doc, runs a macro and saves. Now I need the saved word doc renamed. In the filename, I need to search the filename for a 4 digit alpha-numeric code. I need to take that code and search the a table in access for its match. Once found, change the 4 digit code to the text in column 3 (which is full code cleartext). I posted a similar question but figured I wasn't asking the right question. The filenames very based off document info and using consecutive numbers is not an option so batching is out of the question. Not sure where else to go.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Rename files in multiple directories
- Thread starter newestAF
- Start date
Similar threads
- Locked
- Question
- Locked
- Question