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

Have you tried adding :

Application.DisplayAlerts = False

before this, and switching it back on afterwards?

On Jan 30, 11:53 pm, Brouws <stefan.brou...@gmail.com> wrote:
> 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

On Jan 30, 11:53 pm, Brouws <stefan.brou...@gmail.com> wrote:
> 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