VBA does not refresh data when running script, only after [duplicate]

Question

I am trying to refresh data in my excel sheet. The problem is I want to refresh it before i do anything else but it does not work that way- data is refreshed only AFTER script ends. For example:

ActiveWorkbook.Connections("Name").OLEDBConnection.CommandText = "SELECT * FROM ...(not important)"
ThisWorkbook.RefreshAll

REST OF THE SCRIPT WHICH USES ^ DATA

So the rest of my scipt always uses old data. When script it shows refreshed data but it looks like it only hapens AFTER everything.

Does this answer your question? Excel VBA: Screen doesn't refresh during loop — Luuk
– Luuk, Commented Nov 2, 2020 at 13:54

FaneDuru · Accepted Answer · 2020-11-02 14:01:35Z

1

Please, try inserting this line, before refreshing:

ActiveWorkbook.Connections("Name").OLEDBConnection.BackgroundQuery = False

Otherwise, Excel makes the refreshing in background and let the code to continue, processing what exists...

answered Nov 2, 2020 at 14:01

FaneDuru

42.3k4 gold badges22 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jorhanc Over a year ago

It fixed the problem. Thanks for the solution.

FaneDuru Over a year ago

@Jorhanc: Glad I could help!

Collectives™ on Stack Overflow

VBA does not refresh data when running script, only after [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related