<div>
Thank you VERY VERY much! Works like a charm and will same me hours of computer running each day!<br />
Now I just need to re-write my parsing functions!<br />
I am really surprised this method is not used more! It is so much cleaner, faster and easier!<br />
I was really floored when I came across it the first time, and was using it on alot of code (but that was a few years back!)<br />
I just have not don't that type of web automation for a long time.<br />
<br />
Very complete and was there right at the right time (think it was less than 15 min!)<br />
Cheers!<br />
Bruce
</div>


<div>
You're most welcome Bruce. &nbsp;As the saying goes, &quot;there's more than one way to skin a cat&quot;. &nbsp;I only elected to use WinHTTP out of familiarity. &nbsp;Best of luck!
</div>


<div>
<div class="content wysiwyg-content">
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. <br />
I believe it was just the Excel internet or html libraries, but it may have been one of windows APIs.<br />
<br />
I &quot;think&quot; it was something like a &quot;get&quot; command.<br />
<br />
I have about 4000 pages I need to verify nightly and would really like to speed things up.<br />
<br />
I did this in Widows 7 and probably IE9. I currently run Win 10 with Edge. Have not done much webstuff with Edge.<br />
<br />
Thanks!<br />
Bruce
</div>
</div>


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.

Thanks!
Bruce

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Web browsers are applications used primarily to display documents, files and media from the Internet, identified by a Uniform Resource Identifier (URI) that can be a page, image, video or other file. Some browsers require the use of add-ons or extensions to safely render the information they receive; others have systems built into them to perform the same functions.

Web Browsers

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.