vba download data through url

[playtime]

this is just a part of my vba program which downloads the zip files using url.

I was able to download zip files till 31-dec-20 it still works fine if i put last year dates but, doesnt work for 2021 dates.

The server has data only for below dates
22-dec-20 https://www1.nseindia.com/content/historical/EQUITIES/2020/DEC/cm22DEC2020bhav.csv.zip
23-dec-20 https://www1.nseindia.com/content/historical/EQUITIES/2020/DEC/cm23DEC2020bhav.csv.zip
04-Jan-21 https://www1.nseindia.com/content/historical/EQUITIES/2021/JAN/cm04JAN2021bhav.csv.zip

for 4th-Jan-2021, if i visit the website directly i can download the file by clicking on the link. But, if I copy the same link and paste on address bar the file doesnt download.
pls help I need to download more files using vba.

here is the server address

https://www1.nseindia.com/products/content/all_daily_reports.htm

and I am concerned with the very first file in the left column named" Bhavcopy file(csv) under daily reports

thanks

 

[Kerryx]

Same issue was discussed here

Access denied error when downloading file using PowerShell

I am getting access denied error when I try to run the below script to download the files from NSE sites. If I use the same URL in a web browser then the files can be downloaded. $out="H:\Trade_Fo...

stackoverflow.com