How Download the Data from Website which is inside the hyperlink and no csv extention

[pwnyadav007]

Hi All,

I am stuck in between data capturing from Nse website :-"https://www.nseindia.com/products/content/equities/indices/historical_pepb.htm" .

I want to download the data and show it in my Thisworkbook, but the problem is site is not providing the data in csv format. I have write a code to accomplish this task but stuck at the end where I need to download and show it in Thisworkbook where my code is written. My code is as below:

Please Login or Register  to view this content.

Please let me know if you have any query.

Regards,
Pawan

[AlphaFrog]

Add these lines after the file is downloaded.

Please Login or Register  to view this content.

It calls this function to import the CSV file.

Please Login or Register  to view this content.