V vatluri3101 New Member Sep 16, 2012 #1 How to use web queries to import data from a Streaming Source?
K keymaster New Member Sep 17, 2012 #2 You can set up webquery to refresh every 1 minute or so. This way you will get latest data, although your Excel would remain busy most of the time. Another option is to use REST API thru VBA to fetch data in background. This way, you can control the refresh frequency better.
You can set up webquery to refresh every 1 minute or so. This way you will get latest data, although your Excel would remain busy most of the time. Another option is to use REST API thru VBA to fetch data in background. This way, you can control the refresh frequency better.
