I am looking for the code that will select an open document and place in a variable that can be then used to merge with a specified form. The user steps are as follows:
1. .dat file is opened
2. macro is selected (first step in macro is to pull this open .dat file into a variable)
3. user is presented a dialog box choosing from 4 forms
4. merge is performed with variable and form
5. end of macro
Macro fails because the variable is not recognized as a .dat file.
Any help would be appreciated.
1. .dat file is opened
2. macro is selected (first step in macro is to pull this open .dat file into a variable)
3. user is presented a dialog box choosing from 4 forms
4. merge is performed with variable and form
5. end of macro
Macro fails because the variable is not recognized as a .dat file.
Any help would be appreciated.