Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bypassing Excel's FTP login/password dialog
Have you tried adding :
Application.DisplayAlerts = False before this, and switching it back on afterwards? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypassing File Version Dialog on Save | Excel Programming | |||
Bypassing OK/Cancel Dialog Box | Excel Programming | |||
Bypassing OK/Cancel Dialog Box | Excel Programming | |||
Error Trap for bypassing Password Protection | Excel Programming | |||
Bypassing password | Excel Programming |