Any way to pull in data from already-open web pages (without reloading them?)

d0rian

Active Member
Joined
May 30, 2015
Messages
313
Office Version
  1. 365
Goal: scrape data from ~300 web pages (of identical format), each with stock market data for a different symbol. I currently use VBA that uses Excel's built-in Web Query tool to loop through all 300 URLs, pulling the data from each as it goes. Problem is that it takes ~5 minutes, which I want to cut way down, if possible.

Best idea I can think of so far: I can use a batch file to batch open all 300 URLs in Chrome or Firefox tabs, and they all load completely in about 30-45 seconds. Once they're open in a browser window is there any way for me to direct Excel to grab the data from them? If I understand correctly, if the data is displayed, it exists SOMEWHERE locally on my cpu, right? E.g. even if it's just in a local temp or cache folder, right? So my thinking is that there must be a way to direct Excel to grab it from that local source, rather than have it perform a whole new web query, which as I wrote takes nearly 5 minutes.

(Another thought: even if the browser-displayed data doesn't exist locally such that i can direct Excel to fetch it from there, there are browser extensions I'm playing with that claim to save all data in open tabs to local HTML files...which would seem to be a very simple source to query...but creating those files adds minutes to the process....reducing the time savings I'm attempting to achieve, so hoping there's a way to stick to the ~45s time it takes to load all of the URLs in tabs, and have Excel fetch it directly from there.)

Thoughts?
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Bump for any thoughts? (If I'm wrong, and browser-displayed content isn't actually saved locally upon page-load, then I'm guessing this isn't possible...but I'm pretty sure it is(?))
 
Upvote 0

Forum statistics

Threads
1,223,885
Messages
6,175,187
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top