Solved: Get portion of search results

[Emily]

Following link shows some example of "tram" used in a sentence.
http://sara.natcorp.ox.ac.uk/cgi-bin/saraWeb?qy=tram


Excel query seems not able to get the list in the above link.

I would like to have "Tram" store in Cells (1,1) and list part of reults searched, say 5 sentences, in worksheet. Also, is it possible to not get A3M 66 as shown as below?

A3M (http://thetis1.bl.uk/BNCbib/A3.html#A3M) 66 But the modern tram could hardly be more different.

Thanks in advance.
Emily


Edit on 19 Jan 2007
Cross Post: http://www.mrexcel.com/board2/viewtopic.php?t=253047

[Simon Lloyd]

Emily check out this link to MS Knowledge base http://support.microsoft.com/kb/152568 it should have what you need with a worked example!

Regards,
Simon

[Emily]

Simon

The link cannot help me to get search data to worksheet.

Anyway, thanks

[vonpookie]

Have you tried a web query?

[Emily]

Have you tried a web query?

As mentioned in the question, Excel query seems not able to get the list in the above link.

[Simon Lloyd]

Emily, excel cannot get the information you require from your search as it isn't in a table format.

Regards,
SImon

[Ivan F Moala]

Emily, I replied @ MrExcel

[Emily]

Thanks Ivan