Download CSV File from Website

Hi,

I would like to download a csv file from internet through vba. Let me explain in detail, I have csv file website link in Excel(cell A1),
What I need to do is when I run the macro code
1. To copy the link in Cell A1 and search the default web browser in system
2. Paste the link in url path and download and save to a specific folder in local drive without any dial box(open/save/save as etc.)
3. When save as to local folder, replace the file if already exists in the same name


Any help would be greatly appreciated.

Thanks,
Chinraj

Originally Posted by HaHoBe

Range A1 holds the information to the file as follows:

http://pic.dhe.ibm.com/infocenter/ti...leteSample.csv

Code is inserted in a standard module:

Hi Ciao,
Thank you very much for the reply. I have tried the above code with same steps, it works perfectly with your link in cell A1.
But I put my own link(https://confidential/report.csv), it shows a Run-time error '1004' like below,
'C:\Documents and Settings\Chinraj\My Documents\reports.csv' could not be found. Check the spelling the file name, and verify that the file location correct.
If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, deleted.

But I copy the link in cell A1 and put in my web browser url path by manually, then its working(downloading) the file. The above code is not supports to download the file from secured(https://) server, is it?

PS: The same code has worked fine in my colleague's system for some time(NOT ALL THE TIMES). Sometime they are also getting the same error message.

Hi Patel, thanks for the code. But the result seems like above error for some time.

Regards,
Chinraj

Originally Posted by HaHoBe

Range A1 holds the information to the file as follows:

http://pic.dhe.ibm.com/infocenter/ti...leteSample.csv

Code is inserted in a standard module:

Hi Ciao,
Thank you very much for the reply. I have tried the above code with same steps, it works perfectly with your link in cell A1.
But I put my own link(https://confidential/report.csv), it shows a Run-time error '1004' like below,
'C:\Documents and Settings\Chinraj\My Documents\reports.csv' could not be found. Check the spelling the file name, and verify that the file location correct.
If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, deleted.

But I copy the link in cell A1 and put in my web browser url path by manually, then its working(downloading) the file. The above code is not supports to download the file from secured(https://) server, is it?

PS: The same code has worked fine in my colleague's system for some time(NOT ALL THE TIMES). Sometime they are also getting the same error message.

Hi Patel, thanks for the code. But the result seems like above error for some time.

Regards,
Chinraj