Loop web query & pivot table...?

J

J.W. Aldridge

I have a web query that pulls data from a web page that updates
constantly.

Based on the data from the web query, I have a pivot table that
organizes the data found.

What is the best way (or rather how do I) to loop a web query to keep
it updated at all times?
Also how do I loop the pivot table refresh option to do the same?

Or am I asking too much of vba/excel?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top