Macro to generate a table from query

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

how can i bypass the yes or no option during generating a table.

sendkey?

Thanks a lot.
 
Use the SetWarnings action. Before you run the query, use this step:

Action: SetWarnings
Expression: No

After you run the query, I recommend that you use this step (although macros
usually turn this action back on automatically when the macro finishes):

Action: SetWarnings
Expression: Yes
 
thanks for detailed explanation.


Ken Snell said:
Use the SetWarnings action. Before you run the query, use this step:

Action: SetWarnings
Expression: No

After you run the query, I recommend that you use this step (although macros
usually turn this action back on automatically when the macro finishes):

Action: SetWarnings
Expression: Yes
Click to expand...
 
Back
Top