Hello

I am trying to automate a save to my ftp site, but there does not seem to be
a way to do it without user intervention. Using the following code, I still
get a dialog box asking for user (required) and password:

Sub SaveFTP()
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs FileName:= _
"ftp://208.37.158.126/home/data/myfile.csv", FileFormat:= _
xlCSV, Password:="juicy122", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=True
End Sub

Any ideas?

W