如何使用vba excel在网页上获得href值？

问题描述

我是excel vba编程的新手。我一直在尝试使用excel vba在网页上获得href值近2天。请帮帮我。由于我是新手，我可能犯了很多错误。请原谅我。方案是：html designi之后的特定网页想要获得像 www.abc.com ， www.xyz这样的hef值.com ， www.ybx.com

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

<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>

推荐答案

这篇关于如何使用vba excel在网页上获得href值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！