Need vba to download and copy the data from zip file

[vjvijay88]

i need to download the zip file and copy the data from csv and paste in workbook without opening

https://www.nseindia.com/content/historical/DERIVATIVES/2016/DEC/fo26DEC2016bhav.csv.zip
the link contains the file in zip format but it has only one csv file inside and i need to copy in my download sheet help me

 

[Vaishali]

Hi ZVI,

Thanks a lot for such prompt answer !!!

This has resulted same as I was expecting. But there is a minor thing left which I could not mention at the time of sending my querry.

This code is resulting as below

https://www.nseindia.com/content/historical/EQUITIES/2019/Jun/cm08JUN2019bhav.csv.zip

But there is a minor change in Format of Month Name as below (REQUIRED IN CAPS)

https://www.nseindia.com/content/historical/EQUITIES/2019/JUN/cm08JUN2019bhav.csv.zip

Kindly help me for this change too.

Regards.

Sir,

Is the above link working for you? When I try to load that page for 1st Apr 2020, I am getting 404 page. The link from which I can download the zip file is

https://www1.nseindia.com/content/historical/EQUITIES/2020/APR/cm01APR2020bhav.csv.zip

.