How to replace table column tags

[JayeshG]

Hello,

Is there any way we can pull only one table column from website table?

The table column tags I want to pull from the site goes something like this:

<td align=right><span alt="2 of 5 stars" title="2 of 5 stars" class="NoWrap"><img src="/i/star-on.png" height="16" width="17" /><img src="/i/star-on.png" height="16" width="17" /><img src="/i/star-off.png" height="16" width="17" /><img src="/i/star-off.png" height="16" width="17" /><img src="/i/star-off.png" height="16" width="17" /></span></td>

Is there any way we can replace this string of tags with this:

<td align=right>2 of 5 stars</td>

------

or another way, can we manipulate the same thing in clipboard? When I copy the table content from website with the help of getElementById, is there any way we can replace those tags and paste in the column?


If anyone can help me out with this?

Thanks!

[Marc L]

Hi,

easy beginner way is to use worksheet assistant of New query on the web (QueryTable object in VBA) …

If you have enough skills in HTML and VBA, see this thread with both ways :
one reading cells from table and other using clipboard !

Evidence that it is faster to perform a search in the forum than waiting for a possible response !

[JayeshG]

Thanks Marc, Leith helped me with the code.