Avatar of Bruj
Flag for United States of America

asked on 

How to get a webpage data without navigating to it. VBA

I came across a technique a few years back that allowed me to grab data from a webpage without navigating to that page. I was actually very simple, but I forgot how to did it.
I believe it was just the Excel internet or html libraries, but it may have been one of windows APIs.

I "think" it was something like a "get" command.

I have about 4000 pages I need to verify nightly and would really like to speed things up.

I did this in Widows 7 and probably IE9. I currently run Win 10 with Edge. Have not done much webstuff with Edge.

Microsoft ExcelVisual Basic ClassicWeb BrowsersVBA

Avatar of undefined
Last Comment
Jon von der Heyden

8/22/2022 - Mon