Bypassing Excel's FTP login/password dialog

[tyler.paavola]

Hi all,

Currently, I am using

Workbooks.OpenText Filename:= "ftp://usernameassword@ftpservername/
directory" & (some other parameters)

to connect to a ftp server to download files that will generate my
data.

The script works great, the only problem is that it brings up a FTP
login screen, prompting for the username and password.
This script needs to be automated, so I cannot have a login dialog
box.

As shown above, I have put the username and password details within
the ftp link, but the dialog box is still displayed.


Any ideas?
many thanks in advance

 

[Brouws]

Have you tried adding :

Application.DisplayAlerts = False

before this, and switching it back on afterwards?

 

[tyler.paavola]

Have you tried adding :

Application.DisplayAlerts = False

before this, and switching it back on afterwards?

Yeah, I've tried that, but the login dialog still comes up
I am thinking I need some way of passing it the username/password,
because I don't think I can suppress the dialog and still have it log
into a secure ftp

 

[tyler.paavola]

Have you tried adding :

Application.DisplayAlerts = False

before this, and switching it back on afterwards?

Yeah, I've tried that, but the login dialog still comes up
I am thinking I need some way of passing it the username/password,
because I don't think I can suppress the dialog and still have it log
into a secure ftp