Bypassing Excel's FTP login/password dialog

Hi all,

Currently, I am using

Workbooks.OpenText Filename:= "ftp://username:password@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
.