I am trying to create a button with a macro code. When the button is pressed it will run a refresh code for a webpage. One of the sheets is updated with the information from this website. There is a waiting period for the refreshing. When done refreshing the rest of the code is run. My problem is the waiting part. Depending on my location and internet speed it sometimes takes 2 seconds to load and sometimes 8 seconds. I want create a timer that will look at when excel is refreshing, wait till its done and then run the rest of the code. See below for a small exable.
Simple code:
Here I need the delay or waiting code till all the refreshing is finished... Then
Hope anyone can help!!
Simple code:
Code:
ActiveWorkbook.RefreshAll
Here I need the delay or waiting code till all the refreshing is finished... Then
Code:
MsgBox("The Refreshing is Completed!")
Hope anyone can help!!