I used Excel Data>From Web>Webquery feature to insert Stock Information in an excel sheet. It automatically updates after 3 minutes (data is getting overwritten).
I want to run a specific macro everytime Excel updates the webquery after 3 minutes. Doing this I can keep track of the stock prices at different time periods during the day.
Thanks