I have a word macro that separate different documents attached in one attachment. There are several different documents this works for. I use a word macro to split the docs and save individually. Part of the name saving function is to search the document for the last 4 of the agency code. I have an excel spreadsheet which I want to import into access to reference. The xls has 3 columns to be referenced: agency, admin agency, admin description. How can I get the macro to reference this xls or table to change the agency's code to the admin agency cleartext?
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Word Macro to Reference MS Access Table
- Thread starter newestAF
- Start date
Similar threads
- Locked
- Solved
- Locked
- Helpful tip
- Locked
- Question