Downloading File with VBA

[Dohko]

Hi,

How can I write some code to download a file from a website programatically?

Say I want to download abc.xls that is located at www.google.com/abc.xls
and save it to c:\temp\abc.xls.

Without getting any prompts, just overwrite the file if it exists.

Thanks.

 

[John_w]

Have a look at the Windows API functions URLDownloadToFile or URLDownloadToCacheFile.

 

[Dohko]

CAn i do this in the background without opening the file?

 

[John_w]

Both those functions just download the file, they don't open it. As for in the background, maybe try calling one of them in an Application.OnTime procedure, or search for asynchronous download.

Alternatively, if the file is a .xls, as your URL indicates, Excel itself can download it. Try File - Open - the URL with the macro recorder running to generate the VBA code.

 

[Dohko]

I tried downloading the file, but since its a CSV file it is not the original file once it is saved by excel.

This is what im doing..

Workbooks.Open Filename:="http://blabla.com/table.csv"
Application.DisplayAlerts = False
Windows("table.csv").Activate
ActiveWorkbook.SaveAs Filename:="C:\blabla\export.csv", FileFormat:=xlCSV _
, CreateBackup:=False
ActiveWorkbook.Close savechanges:=False

Can someone show me how to copy the file without opening it perhaps?