how to delay macro without stoping import??

[hanman]

Im trying to import data from a terminal, however the terminal is not fast enough so I need to delay the macro.

If i use the

Application.Wait Now + TimeValue("0:00:01")

the import freezes too. What do I do? Is there another command or way to get around this?

 

[kpark91]

Try increasing the waiting time to 2 seconds.
The excel does not handle Wait too well..

If that doesn't work as well, try adding DoEvents in front of your code like this.

Sub Blarg()
    DoEvents
    'Your Code
End Sub

However, please note that DoEvents will take up alot of CPU.

 

[Ruddles]

If your data is appearing in a worksheet cell then it may be possible to use an event handler to detect its appearance and process it.

How is the data being 'imported'?

The bottom line is, I think, that we'll need to see your code in order to advise you.