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 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