troubleshooting Question

Extract Data from Web Page without Tags

Avatar of rsburge
rsburgeFlag for United States of America asked on
VBA
8 Comments2 Solutions152 ViewsLast Modified:
I need to extract data from a web page using VBA.  I have everything working but when I get to the webpage, there is only a single number returned and I am not sure how to pull that number into a variable.  There are no tags to reference.

This is an example that I am working with.

https://192.168.1.242/act_pricerequest_count.cfm?LoanDate1=4/15/2018&LoanDate2=5/14/2018

I simply use IE.navigate "https://192.168.1.242/act_pricerequest_count.cfm?LoanDate1=4/15/2018&LoanDate2=5/14/2018" to get to this page.  I just need to know how to get the number returned, 62, into a variable of rngAutomated.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros