ftp downloader in vba

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
1.96K views
0

Hi,
Thanks for this great site!
Just found and tested your ftp downloader code. It worked nice for two days. Then it stopped functioning. Though i have changed network, i wonder if there is anything to do with that. I can access the ftp located file via Total commander of via a direct ftp connection setup in explorer, however filezilla fails for some reason. I wonder too if it is a server site problem. Where shall i look for log?
regards
andrew

0

Hi Csaba,

I would bet that it is a problem of a proxy server being used in your new network. You can add a line using InternetSetOption function. See documentation here:
https://msdn.microsoft.com/en-us/library/aa384220(VS.85).aspx

You should be able to find the proxy details in your Internet Explorer (Edge) browser settings.

commented on answer
Avatar

May this problem have to do something with ftp passive mode? Figured out that total commander ftp connection is only working if passive mode is pick? In your code i do not find this part

Avatar

There is no proxy

Simply the best place to learn Excel VBA