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

Brand	Unbrako
Catalogue Page Number	03-62
Diameter	1/2 inch
Finish/Colour	Black
Head Type	Cap
Item	Socket screw
Length	2-1/2 inch
Material	Alloy Steel
Metric/Imperial	Imperial
Minimum Order Quantity	1
Order Quantity Multiple	1
Package Quantity	50/Pack
Standard Pack Quantity	50
Thread Size	1/2 inch
Thread Type	UNC
TPI/Pitch	13

<tbody>
</tbody>

[/COLOR]

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


need it in this format:

Blackwoods part number	Mfr_Name	Mfr_Part number	Description	Spec Name	Spec Value
01861905	Unbrako	CNC12/212	SCREW CAP SKT HD UNBRAKO UNC 1/2X2 1/2	Brand	Unbrako
				Catalogue Page Number	22706
				Diameter	1/2 inch
				Finish/Colour	Black
				Head Type	Cap
				Item	Socket screw
				Length	2-1/2 inch
				Material	Alloy Steel
				Metric/Imperial	Imperial
				Minimum Order Quantity	1
				Order Quantity Multiple	1
				Package Quantity	50/Pack
				Standard Pack Quantity	50
				Thread Size	1/2 inch
				Thread Type	UNC
				TPI/Pitch	13

<tbody>
</tbody>

Can anyone help me with this please i am in urgent need of it.

Thank you