VBA file download

[mattey28]

Hi,
is there an easy way to simply download file from eg.:
http://www.mts-ceto.pl/mts/notowania/biuletyn-20070809.xml
and store it in local folder... F:/FILES
I don't want to import it to my spreadsheet at this point, just want to dwonload it.

I've tried FileCopy but it doesn't work.

ZILLION THX for help

 

[Joe Was]

See if my code in this post helps?

http://www.mrexcel.com/board2/viewtopic.php?t=248046

 

[mattey28]

Thanks Very nice code! It crashes sometimes, especially when I give wrong url, but you gave me idea how to obtain my goal

Thanks again!

 

[Joe Was]

Tak W porzadku.

You can add to it, to Improve and expand the code and add error trapping, as needed.