VBA Macro running too fast

Question

It's weird that I'm finding ways to slow down my macro. Apart from Doevents and other time delay techniques, which are basically a workaround, is there a way through which we can get around the asynchronous execution. As in, I want the VBA code to behave like this:

start executing line 1>finish executing line 1>move to line 2;

Forgive if I'm wrong but currently it seems to follow:

Start executing line 1>without caring whether line 1 finished or not start executing line2

Please post your code - otherwise, we won't be able to help you. — dwirony, Sep 08 '17 at 13:28
this has nothing to do with execution speed of vba but rather that it appears you are calling functions that run asynchronously — Luke Kot-Zaniewski, Sep 08 '17 at 13:33

score 0 · Answer 1 · answered Sep 08 '17 at 13:41

If you are calling external programs (vbs, exe) then the vba isn't getting any feedback on the process at all. It calls the programs and moves on to the next line of code (the vba doesn't know if/when the external programs finishes). One way to slow this process down would be to put a application.wait or application.sleep between the calls, but that is also a workaround. Please post your actual code and perhaps we can troubleshoot further.

Volkan Yurtseven · Answer 2 · 2017-09-08T14:11:54.000

0

if the code is about refreshing data, use Refresh method with backgroundquery=False in a For Loop instead of RefreshAll.

For Each con In Me.Connections
    con.ODBCConnection.BackgroundQuery = False
    con.Refresh
Next

edited Sep 08 '17 at 14:11

answered Sep 08 '17 at 13:41

Volkan Yurtseven

425
3
15

VBA Macro running too fast

2 Answers2

Linked