Can't update the data from internet while running macro
 

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 ??:confused:


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Can't update the data from internet while running macro
 

Use the refresh method command in your macro to update?

--
Regards,
Tom Ogilvy

"wilson" wrote in message
...

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 ??:confused:


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Can't update the data from internet while running macro
 

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Can't update the data from internet while running macro
 

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)


--
Regards,
Tom Ogilvy


"wilson" wrote in message
...

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/