save password for ftp drive for data connection

[San75]

Hi Guys. When i refresh my workbook it keeps giving this error. It updates a sheet from a FTP location. How can save the password so I don't need to enter it each time to provent this error?

Thanks.

[AlphaFrog]

1. Click a cell in the external data range.
2. Click Data > Connections, click the arrow next to Refresh All, and then click Connection Properties.

eb718c0f-e633-4a84-bda1-413a915f4526.jpg

1. Click the Definition tab.
2. Add your password

[San75]

Thanks. I did try that and the save password box is checked. I have the below in the connection string. Should the User ID be for the PC or FTP? I have noticed there are many Password="". Should one of these be for the FTP?

Provider=Microsoft.ACE.OLEDB.12.0;Password="";User ID=Admin;Data Source=C:\Users\XXXXXXX\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\XXXXXXX.xls;Mode=Share Deny Write;Extended Properties="HDR=YES;";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=35;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False;Jet OLEDB:Limited DB Caching=False;Jet OLEDB:Bypass ChoiceField Validation=False

[AlphaFrog]

Sorry. I don't know the answer to that one. You can test it by putting the passwords in and see what happens.