Run macro when Excel Webquery Updates - TechRepublic
Question
March 21, 2009 at 10:53 PM
arpeggio

Run macro when Excel Webquery Updates

by arpeggio . Updated 17 years, 3 months ago

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

This discussion is locked

All Comments