View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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 ??


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