Question Locked
Run macro when Excel Webquery Updates
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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