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

1 reply

This discussion is closed to new replies.