G
Glavall
I have designed some macros that have created two specific challenges for me.
1. The first is a an import function. Aside from having the end-user
selecting the file to import, all prompts for the import function will always
be answered the same way. How do I set up the macro to continue through the
remaining prompts for the import process with my personal default answers?
2. The second is a variation of the first. My other macro gets to a point
where the user is informed of the results of the operation (in this case, the
append query results) and requires the end-user to click ok. How do I get
the macro to automatically respond ok and continue without end-user action?
1. The first is a an import function. Aside from having the end-user
selecting the file to import, all prompts for the import function will always
be answered the same way. How do I set up the macro to continue through the
remaining prompts for the import process with my personal default answers?
2. The second is a variation of the first. My other macro gets to a point
where the user is informed of the results of the operation (in this case, the
append query results) and requires the end-user to click ok. How do I get
the macro to automatically respond ok and continue without end-user action?