dimanche 1 juillet 2018

Web scrapping of masked URL using VBA

I want to scrap some stock data from a website called "https://dps.psx.com.pk/" using VBA in excel, but the problem is the URL of this website does not change.

I just need to input the quote symbol eg:"EFOODS" on the top right corner box stating "get quote" and it gives the details as highlighted in the image given. All those 3 boxes I want to scrap in excel using VBA.

I have wasted my entire week in searching the web for the solution but got no help, so I have high hopes from the members of this forum to provide me the detailed solution of my problem.

Thanks in advance...

Here is the image:

enter image description here




Aucun commentaire:

Enregistrer un commentaire