Thread: Extract Data from a URL stored in a Cell

Hey
I've had a read through other posts relating to dynamic web queries but they couldn't help me.

I have an excel spreadsheet containing a list of URLs in column C and I am trying to extract the data within the following tags:

<table cellpadding="0" cellspacing="0" border="0" align="center" width="580" id="header">
<tr style="background: #003467 url(/lectopia_data/delivery/templateimages/header-1.gif) top left no-repeat;" height="66">
<td align="right"><div style="width:50%"><h2 style="color: #FFFFFF;">internet demo (00020)</h2></div>
</tr>
</table>

so that the text "internet demo (00020)" is saved into the adjacent cell in column D.

Could anybody please help create a dynamic query to achieve this? or am i going about this the wrong way by using excel?
Thanks
Frank

That doesn't look like a URL to me, more like some HTML code.

Is all of that in one cell? Or are the lines of HTML in separate cells? Is the information you want always after an H2 level heading?

A sample workbook with some typical data might help advance your cause here.

Regards

As I said,

A sample workbook with some typical data might help advance your cause here

Regards

I've put together a routine to get the source code and extract the header.

However, I'm not 100% confident as the output varies. I'm guessing it's a timing problem and I've tried a few things to overcome it, the last being to navigate to the page twice.

Anyway, have a look and see if it works any more consistently for you ... you'll see the various attempts.

I'm probably missing something very basic but I just don't know what it is ;-(

Regards

Excellent. I have to admit, I wasn't that confident but maybe it works better if you're local to the servers.

Thanks for the rep.


Regards