Bypassing Excel's FTP login/password dialog

  • Thread starter Thread starter tyler.paavola
  • Start date Start date
T

tyler.paavola

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
 
Have you tried adding :

Application.DisplayAlerts = False

before this, and switching it back on afterwards?
 
Have you tried adding :

Application.DisplayAlerts = False

before this, and switching it back on afterwards?
Click to expand...

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
 
Have you tried adding :

Application.DisplayAlerts = False

before this, and switching it back on afterwards?
Click to expand...

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
 
Back
Top