ajishkumar
New Member
- Joined
- Dec 8, 2009
- Messages
- 15
Hello,
I have a table like follows:
<table style="border-collapse: collapse; width: 662pt;" width="882" border="0" cellpadding="0" cellspacing="0"><col style="width: 293pt;" width="390"> <col style="width: 178pt;" width="237"> <col style="width: 191pt;" width="255"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; width: 293pt;" width="390" height="17">URL</td> <td class="xl66" style="width: 178pt;" width="237">Description</td> <td class="xl65" style="width: 191pt;" width="255">Company URL</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt;" height="17">http://www.inc.com/inc5000/2009/company-profile.html?id=200900010</td> <td class="xl67" style="width: 178pt;" width="237">Northern Capital Insurance</td> <td>http://www.northerncapitalinsurance.com/</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt;" height="17">http://www.inc.com/inc5000/2009/company-profile.html?id=200900020</td> <td class="xl67" style="width: 178pt;" width="237">National Retirement Partners </td> <td>http://www.n-r-p.com/</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt;" height="17">http://www.inc.com/inc5000/2009/company-profile.html?id=200900030</td> <td class="xl67" style="width: 178pt;" width="237">Harley Stanfield finances and estate without having to take on the responsibility </td> <td>http://www.harleystanfield.com/</td> </tr> </tbody></table>
I just want to create a macro to go to particular site and capture description and url from this site. It's time consuming if I do copy paste individually.
Is it possible in excel?
Thanks,
Ajish
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
I have a table like follows:
<table style="border-collapse: collapse; width: 662pt;" width="882" border="0" cellpadding="0" cellspacing="0"><col style="width: 293pt;" width="390"> <col style="width: 178pt;" width="237"> <col style="width: 191pt;" width="255"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; width: 293pt;" width="390" height="17">URL</td> <td class="xl66" style="width: 178pt;" width="237">Description</td> <td class="xl65" style="width: 191pt;" width="255">Company URL</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt;" height="17">http://www.inc.com/inc5000/2009/company-profile.html?id=200900010</td> <td class="xl67" style="width: 178pt;" width="237">Northern Capital Insurance</td> <td>http://www.northerncapitalinsurance.com/</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt;" height="17">http://www.inc.com/inc5000/2009/company-profile.html?id=200900020</td> <td class="xl67" style="width: 178pt;" width="237">National Retirement Partners </td> <td>http://www.n-r-p.com/</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl68" style="height: 12.75pt;" height="17">http://www.inc.com/inc5000/2009/company-profile.html?id=200900030</td> <td class="xl67" style="width: 178pt;" width="237">Harley Stanfield finances and estate without having to take on the responsibility </td> <td>http://www.harleystanfield.com/</td> </tr> </tbody></table>
I just want to create a macro to go to particular site and capture description and url from this site. It's time consuming if I do copy paste individually.
Is it possible in excel?
Thanks,
Ajish
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">