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 |
Bypassing Excel's FTP login/password dialog
Have you tried adding :
Application.DisplayAlerts = False before this, and switching it back on afterwards? |
All times are GMT +1. The time now is 06:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com