XL97: Using Microsoft Excel to Save a File to an FTP Site (172034)

MORE INFORMATION

How to Save a File to an FTP Site

In Microsoft Excel 97, you can save a file to an FTP (File Transfer Protocol) site by performing the following steps:

1. On the File menu, click Save As.
2. In the File Name edit box, type the path to the FTP site. For example:

   ftp://myftp

   Press ENTER.
3. Then, type the name of the file (myfile.xls, for example) in the File Name edit box, and click Save.

Note that you can combine steps 2 and 3 into a single step by typing the complete path to the FTP site and the file. For example, you can type the following into the File Name edit box and press ENTER.

Saving a File when a File with the Exact Same Name Exists

When you save a file to an FTP site, Microsoft Excel 97 determines whether a file with the exact same name already exists in that location. If such a file exists, you receive a warning message similar to the following: If you click Yes, the existing file is replaced. If you click No, you are returned to the Save As dialog box. This is normal behavior in Microsoft Excel.

Saving a File when a File with a Similar Name Exists

If you save a file to an FTP site, and the FTP site already contains a file whose name is the same as the new file except for case, you do not receive a warning message.

For example, if the FTP site ftp://myftp already contains a file named "myfile.xls", you will not receive a warning message if you save a file named "MYFILE.xls" to the same location, because, technically, the file names are different.

However, the original file may be overwritten by the new file. This problem may occur if your FTP server is running Microsoft Windows NT, version 4.0 or earlier, or any other operating system that does not support case sensitivity in file names. NOTE: This problem does not occur when saving files to an FTP server that is running UNIX.

Following the example shown above, the new file "MYFILE.xls" may overwrite the original file "myfile.xls". To prevent this problem from occurring, make sure that your file names differ in some manner other than case; for example, add one or more other characters to the file name, so that it is unique.