Hi,
We receive HTML source code as excel dump that has lot of href attribute which points to a URL.Our knowledge team has to do a Ctrl+F to find each href within a code and list the URL in next column.This is a time consuming process
Iam looking for a VBA solution which can make this process simpler.Here is a sample data.
<tbody>
</tbody>
Desired Output in next sheet or file
<tbody>
</tbody>
Thanks in advance !!
Bhaggs
We receive HTML source code as excel dump that has lot of href attribute which points to a URL.Our knowledge team has to do a Ctrl+F to find each href within a code and list the URL in next column.This is a time consuming process
Iam looking for a VBA solution which can make this process simpler.Here is a sample data.
Answer Id | HTML Source |
1 | Some html source code then more html text and one more <href="http://www.oracle.com"> and then one more <href="http://www.microsoft.com"> |
2 | Some html source code then more html text and one more <href="http://www.google.com"> and then one more <href="http://www.ibm.com"> |
3 | Some html source code then more html text and one more <href="http://www.yahoo.com"> and then one more |
<tbody>
</tbody>
Desired Output in next sheet or file
Answer Id | URLs |
1 | http://www.oracle.com |
1 | http://www.microsoft.com |
2 | http://www.google.com |
2 | http://www.ibm.com |
3 | http://www.yahoo.com |
<tbody>
</tbody>
Thanks in advance !!
Bhaggs
Last edited: