How to get on a href value on web page using vba excel ?

Question

0.00/5 (No votes)

See more:

I am new to excel vba programing. I have been trying to get href value on a web page using excel vba from almost 2 days now. Please help me out. Since I am new to this I might have made a lot of blunders. Pardon me for that.The scenario is : A particular web page following html designi want to get hef value like www.abc.com, www.xyz.com, www.ybx.com

HTML

<div>
   <span class="One">
   <a href="www.abc.com"> subhash </a>
   </span>
   </div>
   <div>enter code here`
   <div>
   <span class="One">
   <a href="www.xyz.com"> mandar</a>
   </span>
   </div>
   <div>
   <span class="One">
   <a href="www.ybx.com"> Onkar</a>
   </span>
   </div>

Posted 9-Apr-14 1:49am

Yogesh_Chavan

Updated 9-Apr-14 2:31am

Maciej Los

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-04-09T02:37:00

Solution 1

I suggest to use Regex with proper pattern for site address (url)[^].

Have a look here: Simple Regular Expression Tutorial for Excel VBA[^]
Regular Expressions in VBA[^]
How To Use Regular Expressions in Microsoft Visual Basic 6.0[^]
The Regular Expression Object Model[^]

Posted 9-Apr-14 2:37am

Maciej Los

Comments

Yogesh_Chavan 10-Apr-14 2:11am

Thanks Maciej Locs . i am use the following logic . but getting me the some error . is this posiable to my logic thanls in advance

Set internetdata = internet.Document
Set div_result = internetdata.getelementbyclassname("one")
set links= div_result.getelementbytag("a")
For Each l In links_links
Set url = l.ChildNodes.Item
next

Maciej Los 10-Apr-14 2:35am

Please, read my answer one more time. You are using Regex nowhere!