Need a scraping tool of blackwoods

[Kirankarthikr]

Hi all,

I have certain number of part number of blackwoods. can anyone help me build a VBA tool to scrape some information from the website using those part numbers.

Ex:

Part Number: 01861905
When you search it in blackwoods website you will find below link

https://www.blackwoods.com.au/part/01861905/screw-cap-skt-hd-unbrako-unc-12x2-12


I need information such as

SCREW CAP SKT HD UNBRAKO UNC 1/2X2 1/2


[COLOR=rgba(0, 0, 0, 0.87)]Unbrako |Blackwoods #: 01861905 |Mfr #: CNC12/212 |UNSPSC #: 31161518





[TABLE="class: mdl-data-table mdl-js-data-table part-attributes-table part-price-break-tablenew"]
<tbody>[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Brand[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]Unbrako[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Catalogue Page Number[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]03-62[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Diameter[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]1/2 inch[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Finish/Colour[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]Black[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Head Type[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]Cap[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Item[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]Socket screw[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Length[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]2-1/2 inch[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Material[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]Alloy Steel[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Metric/Imperial[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]Imperial[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Minimum Order Quantity[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]1[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Order Quantity Multiple[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]1[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Package Quantity[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]50/Pack[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Standard Pack Quantity[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]50[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Thread Size[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]1/2 inch[/TD]
[/TR]
[TR]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]Thread Type[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]UNC[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EEEEEE]#EEEEEE[/URL] "]
[TD="class: mdl-data-table__cell--non-numeric attribute-name"]TPI/Pitch[/TD]
[TD="class: mdl-data-table__cell--non-numeric attribute-value"]13[/TD]
[/TR]
</tbody>[/TABLE]



[/COLOR]

I need all this information to be extracted to excel using VBA tool.


need it in this format:


[TABLE="width: 1188"]
<tbody>[TR]
[TD="class: xl67, width: 198"]Blackwoods part number[/TD]
[TD="class: xl67, width: 198"]Mfr_Name[/TD]
[TD="class: xl67, width: 198"]Mfr_Part number[/TD]
[TD="class: xl67, width: 198"]Description[/TD]
[TD="class: xl67, width: 198"]Spec Name[/TD]
[TD="class: xl67, width: 198"]Spec Value[/TD]
[/TR]
[TR]
[TD]01861905[/TD]
[TD]Unbrako[/TD]
[TD]CNC12/212[/TD]
[TD]SCREW CAP SKT HD UNBRAKO UNC 1/2X2 1/2[/TD]
[TD]Brand[/TD]
[TD]Unbrako[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Catalogue Page Number[/TD]
[TD="class: xl68"]22706[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD][/TD]
[TD]Diameter[/TD]
[TD]1/2 inch[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Finish/Colour[/TD]
[TD]Black[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Head Type[/TD]
[TD]Cap[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Item[/TD]
[TD]Socket screw[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Length[/TD]
[TD]2-1/2 inch[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Material[/TD]
[TD]Alloy Steel[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Metric/Imperial[/TD]
[TD]Imperial[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Minimum Order Quantity[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Order Quantity Multiple[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Package Quantity[/TD]
[TD]50/Pack[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Standard Pack Quantity[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Thread Size[/TD]
[TD]1/2 inch[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Thread Type[/TD]
[TD]UNC[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]TPI/Pitch[/TD]
[TD]13[/TD]
[/TR]
</tbody>[/TABLE]
Can anyone help me with this please i am in urgent need of it.

Thank you