Pause between Macros

  • Thread starter Thread starter mccallen60
  • Start date Start date
M

mccallen60

Hi everyone, I'm hoping someone can help me. I'm running a macro that imports
a .txt file. Sometimes it takes up to a minute for this file to import
completely. I need to know how to keep the next macro from running until this
file finishes importing. If you have a VB answer, please write you suggestion
where a newbie like me can understand. Thanks.
 
Mccallen,

Do I infer that you are using a TransferText action in your macro? If
your meaning then, is that subsequent actions in the macro are executing
before the TransferText is complete, well then I am surprised.

The only way I can think of to handle this would be to split the macro
into two macros, the second being all the actions that run after the
TransferText. Then, in the first one, immediately before the
TransferText. put a SetValue action to set the TimerInterval property of
the form to 60000 (i.e. one minute). And then assign the second macro
on the form's Timer event. The second macro should also have a SetValue
to put the TimerInterval back to 0.

See if that does the job.
 
Back
Top