Can't update the data from internet while running macro

[wilson]

I try to get the data from internet , and want to save it from time to
time , my work sheet is set to update the data when re-opening. But
when I use macro to open it , it will not update the date . How can I
solve this problem ??

 

[Tom Ogilvy]

Use the refresh method command in your macro to update?

 

[wilson]

I have use the "refresh" but the data can't update before the macro copy
the cell

 

[Tom Ogilvy]

You need to set the Backgroundquery property to false - then your macro will
wait for the refresh to complete.

From help for Refresh method:

expression.Refresh(BackgroundQuery)