Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As FTP Settings
I set up an FTP site in the "ADD/Modify FTP Location". Then I used the macro
for the following code: ActiveWorkbook.SaveAs Filename:= _ "ftp://123.456.8.89/filePath/fileName.dat", FileFormat:=xlTextPrinter _ , CreateBackup:=False This works very well. One issue I have is everytime I restart Excel and run the macro I get a run time error. My password that I set up in "ADD/Modify FTP Location" does not get saved after Excel is shut down. Every day I have to enter the password again. It doesn't prompt me to enter the password. I have to go "ADD/Modify FTP Location" and enter the password, then I'm good through out the day. Is there anyway that this password can be permantely saved or can it somehow be done in code? T.I.A. Dayton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save print settings | Excel Discussion (Misc queries) | |||
.pdf save as settings | Excel Discussion (Misc queries) | |||
how do I save/backup my settings? | Setting up and Configuration of Excel | |||
Does Not Save Settings | Excel Discussion (Misc queries) | |||
save settings for reinstall later | Setting up and Configuration of Excel |