Excel Web Query for Data Import

[poldim]

Here is the situation:
I have a list of part numbers that I want excel to look up data from the web page and provide cost information. The specific page for each part number is static with the exception of the part number itself. The built in "From Web" feature currently pulls in 9 lines of information. This would be great if I can have it only display row 4



The part number webpage:
http://www.schneider-electric.us/pr...Detail&partNumber=ATV71LD11N4Z&countryCode=us

Data from "From Web" inquiry:

<table style="border-collapse: collapse; width: 368pt;" border="0" cellpadding="0" cellspacing="0" width="491"><tbody><tr style="height: 15pt;" height="20"><td style="height: 15pt; width: 368pt;" height="20" width="491">ATV71LD11N4Z</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Altivar 71 Lift Drive, 460Vac, 15 HP</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">$2,733.60 List Price</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Non-Stock Item: This item is not normally stocked in our distribution facility.</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Qty.</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20"> Product Datasheet
</td> </tr> </tbody> </table>

For example:
Input part numbers by copying and pasting

<table style="border-collapse: collapse; width: 83pt;" border="0" cellpadding="0" cellspacing="0" width="110"><col style="width: 83pt;" width="110"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 83pt;" height="20" width="110">ATV71LD11N4Z</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">ATV71LD15N4Z</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">ATV71LD18N4Z</td> </tr> </tbody></table>

would be referenced from

<table style="border-collapse: collapse; width: 502px; height: 108px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" height="20" width="64">http://www.schneider-electric.us/products-services/product-detail/?event=productDetail&partNumber=ATV71LD11N4Z&countryCode=us</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">http://www.schneider-electric.us/products-services/product-detail/?event=productDetail&partNumber=ATV71LD15N4Z&countryCode=us</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">http://www.schneider-electric.us/products-services/product-detail/?event=productDetail&partNumber=ATV71LD18N4Z&countryCode=us
</td> </tr> </tbody></table>

-----------------
Ideally, I would like to set it up either in a formula or a macro that would provide me with table: part number; part description; part cost
This is essentially a table with: the input data; row 2 from the web query; and row 4

<table style="border-collapse: collapse; width: 426px; height: 96px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 83pt;" width="110"> <col style="width: 170pt;" width="350"> <col style="width: 52pt;" width="69"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 83pt;" height="20" width="110">ATV71LD11N4Z</td> <td class="xl66" style="width: 250pt;" width="350">Altivar 71 Lift Drive, 460Vac, 15 HP</td> <td class="xl67" style="width: 52pt;" align="right" width="69">$2,733.60 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">ATV71LD15N4Z</td> <td class="xl66">Altivar 71 Lift Drive, 460Vac, 20 HP</td> <td class="xl67" align="right">$3,398.40 </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">ATV71LD18N4Z</td> <td class="xl66">Altivar 71 Lift Drive, 460Vac, 25 HP</td> <td class="xl67" align="right">$4,089.60 </td> </tr> </tbody></table>

 

[poldim]

I just went into the sub routine and pressed and held F8 and saw that it is in fact doing the the actions, I guess the server is just running that much leaner that you do not see anything pop up as oppose to the Win 7 box. TIA