Hi,
I been doing a lot of reading and was not able to find what I'm looking for... I wanted to do a web query in VBA from a list of hyperlink and verify some keywords. If there's already a thread or example regarding what I'm looking for than please direct me as needed.
For example:
Cell (link)
A2 (www.testing.com/123)
A3 (www.testing.com/234)
A4 (www.testing.com/345)
On Cell B2, I want to query the link from A2 and find keywords such as "Connected", "Completed", "Failed" and "InProgress". Once there's a match than update B2 with "Good Data", if there's no match than update B2 with "Bad Data". I wanted to do the same for each hyperlink until it reach the end.
Sorry if this has been posted already..
I been doing a lot of reading and was not able to find what I'm looking for... I wanted to do a web query in VBA from a list of hyperlink and verify some keywords. If there's already a thread or example regarding what I'm looking for than please direct me as needed.
For example:
Cell (link)
A2 (www.testing.com/123)
A3 (www.testing.com/234)
A4 (www.testing.com/345)
On Cell B2, I want to query the link from A2 and find keywords such as "Connected", "Completed", "Failed" and "InProgress". Once there's a match than update B2 with "Good Data", if there's no match than update B2 with "Bad Data". I wanted to do the same for each hyperlink until it reach the end.
Sorry if this has been posted already..
Last edited:
