Hello,

I have list of Industries and the respective companies in the following link

http://www.moneycontrol.com/stocks/m...code=Abrasives

The Hyperlink of Each Company opens the below webpage

http://www.moneycontrol.com/india/st...umuniversal/CU

From the above webpage I need to copy the following into excel sheet

"BSE: 513375 | NSE: CARBORUNIV | ISIN: INE120A01034 | SECTOR: ABRASIVES"

I am completely new to webscraping. Could some one help me , how to automate the task using VBA, so that I could get the required data of all the companies?

Thank you