CanBilgekan
New Member
- Joined
- Jan 15, 2015
- Messages
- 5
Hello,
My Excel table column contains web url's.
Need to VBA code to get spesific html tags inner text and write them to in my row range.[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Links[/TD]
[TD]data1[/TD]
[TD]data2[/TD]
[TD]data3[/TD]
[TD]data4[/TD]
[TD]data5[/TD]
[/TR]
[TR]
[TD]www.abc.com/?d=123 [/TD]
[TD]abc[/TD]
[TD]green[/TD]
[TD]table[/TD]
[TD]34[/TD]
[TD]%65[/TD]
[/TR]
[TR]
[TD]www.abc.com/?d=124[/TD]
[TD]def[/TD]
[TD]blue[/TD]
[TD]chair[/TD]
[TD]63[/TD]
[TD]%66[/TD]
[/TR]
[TR]
[TD]www.abc.com/?d=125[/TD]
[TD]tht[/TD]
[TD]yellow[/TD]
[TD]wall[/TD]
[TD]85[/TD]
[TD]%44[/TD]
[/TR]
[TR]
[TD]www.abc.com/?d=126[/TD]
[TD]ghj[/TD]
[TD]black[/TD]
[TD]pipe[/TD]
[TD]74[/TD]
[TD]%88[/TD]
[/TR]
[TR]
[TD]www.abc.com/?d=127[/TD]
[TD]rer[/TD]
[TD]purple[/TD]
[TD]baloon[/TD]
[TD]55[/TD]
[TD]%77[/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance.
My Excel table column contains web url's.
Need to VBA code to get spesific html tags inner text and write them to in my row range.[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Links[/TD]
[TD]data1[/TD]
[TD]data2[/TD]
[TD]data3[/TD]
[TD]data4[/TD]
[TD]data5[/TD]
[/TR]
[TR]
[TD]www.abc.com/?d=123 [/TD]
[TD]abc[/TD]
[TD]green[/TD]
[TD]table[/TD]
[TD]34[/TD]
[TD]%65[/TD]
[/TR]
[TR]
[TD]www.abc.com/?d=124[/TD]
[TD]def[/TD]
[TD]blue[/TD]
[TD]chair[/TD]
[TD]63[/TD]
[TD]%66[/TD]
[/TR]
[TR]
[TD]www.abc.com/?d=125[/TD]
[TD]tht[/TD]
[TD]yellow[/TD]
[TD]wall[/TD]
[TD]85[/TD]
[TD]%44[/TD]
[/TR]
[TR]
[TD]www.abc.com/?d=126[/TD]
[TD]ghj[/TD]
[TD]black[/TD]
[TD]pipe[/TD]
[TD]74[/TD]
[TD]%88[/TD]
[/TR]
[TR]
[TD]www.abc.com/?d=127[/TD]
[TD]rer[/TD]
[TD]purple[/TD]
[TD]baloon[/TD]
[TD]55[/TD]
[TD]%77[/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance.