Download File from Internet (link on field) and save it(link on field).

[Ucramos]

Hi.
I don´t have a lot of experience using VBA but i think this is the only way to do what i want.

I have a form called "Produtos"
in that form i have 2 fields that i want to use.
"FotoSitePNG" has the full link to a file i want to download like: www.website.com\image01.png
"FotoLocalPNG" has the full link to the dir and file name i want to download to like: D\imagens\image01.png

These links vary with every field on the table, so i wanted to do something like: =downloadfile ([FotoSitePNG], [FotoLocalPNG])



I´ve tried every tip that i found on google, but i can´t get any to work.

Please help.

[June7]

What have you tried and why didn't it work - error messages, bad results? Is downloadfile a Sub or Function procedure you built? Post the code for analysis. Where are you calling this procedure? The = sign makes me think in a textbox or query field and I don't know how that could be successful. Check this article (sample code is VB.net but maybe adaptable) http://vbnet.mvps.org/index.html?cod...ilenocache.htm