Microsoft KB Archive/171094: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 71: | Line 71: | ||
# On the File menu, click Save As. | # On the File menu, click Save As. | ||
# In the Save As dialog box, click Add/Modify FTP Locations in the Save In list. | # In the Save As dialog box, click Add/Modify FTP Locations in the Save In list. | ||
# In the Add/Modify FTP Locations dialog box, enter the name of the FTP site in the | # In the Add/Modify FTP Locations dialog box, enter the name of the FTP site in the "Name of FTP site" box, and then click Add. Click OK. | ||
# In the Save In list, click the FTP site you added in step 5. | # In the Save In list, click the FTP site you added in step 5. | ||
# Enter the name for the document in the File Name box, and then click Save. | # Enter the name for the document in the File Name box, and then click Save. | ||
Line 83: | Line 83: | ||
# On the File menu, click Save As. | # On the File menu, click Save As. | ||
# In the Save As dialog box, click Add/Modify FTP Locations in the Save In list. | # In the Save As dialog box, click Add/Modify FTP Locations in the Save In list. | ||
# In the Add/Modify FTP Locations dialog box, enter the name of the FTP site in the | # In the Add/Modify FTP Locations dialog box, enter the name of the FTP site in the "Name of FTP site" box, and then click Add. Click OK. | ||
# In the Save In list, select the FTP site you added in step 5. | # In the Save In list, select the FTP site you added in step 5. | ||
# Enter the name for the document in the File Name box, and then click Save. | # Enter the name for the document in the File Name box, and then click Save. | ||
Line 117: | Line 117: | ||
== REFERENCES == | == REFERENCES == | ||
For more information about the internet features, click the Office Assistant, type <span class="kbd userinput"> internet</span> click Search, and then click to view | For more information about the internet features, click the Office Assistant, type <span class="kbd userinput"> internet</span> click Search, and then click to view "About Microsoft Excel and the Internet."<br /> | ||
<br /> | <br /> | ||
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base: | NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base: |
Latest revision as of 11:05, 21 July 2020
Article ID: 171094
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q171094
SYMPTOMS
If you use the Internet Assistant Wizard to save Microsoft Excel data as a Hypertext Markup Language (HTML) document or you use the Web Form Wizard to save a worksheet as a form, you may receive the following error message:
CAUSE
This problem occurs if you are trying to save either an HTML document or a Microsoft Excel form to a File Transfer Protocol (FTP) site. The Internet Assistant Wizard and the Web Form Wizard do not support saving files to an FTP site.
WORKAROUND
You cannot use either of these two wizards to save files directly to an FTP site. To work around this problem, use the appropriate following method.
Method 1: Internet Assistant Wizard Users
Create an HTML document by using this wizard. To save the HTML document on an FTP server, follow these steps:
- Create the HTML document by using the wizard and save it locally on your computer.
- Open the HTML document in Microsoft Word 97.
- On the File menu, click Save As.
- In the Save As dialog box, click Add/Modify FTP Locations in the Save In list.
- In the Add/Modify FTP Locations dialog box, enter the name of the FTP site in the "Name of FTP site" box, and then click Add. Click OK.
- In the Save In list, click the FTP site you added in step 5.
- Enter the name for the document in the File Name box, and then click Save.
This method allows you to save the HTML document on the specified FTP site.
Method 2: Web Form Wizard Users
To create and save the form, follow these steps:
- Create the Microsoft Excel form by using the wizard and save it locally on your computer.
- Open the form in Microsoft Excel.
- On the File menu, click Save As.
- In the Save As dialog box, click Add/Modify FTP Locations in the Save In list.
- In the Add/Modify FTP Locations dialog box, enter the name of the FTP site in the "Name of FTP site" box, and then click Add. Click OK.
- In the Save In list, select the FTP site you added in step 5.
- Enter the name for the document in the File Name box, and then click Save.
This method allows you to save the form on the specified FTP site.
STATUS
This behavior is by design of Microsoft Excel.
MORE INFORMATION
Internet Assistant Wizard
You can make Microsoft Excel data available to users on your intranet or on the World Wide Web so that anyone who has a Web browser can view it. Use the Internet Assistant add-in to convert worksheet data or charts to HTML Web pages that you can post on the Web.
Web Form Wizard
Requesting and gathering information over the Internet requires using forms. In addition, you must have some knowledge of the server, database storage, and computer programming.
Because you can use a Microsoft Excel worksheet to simulate a form, you can use Microsoft Excel 97 as an engine to generate a form for the Web.
When others visit your Web site and make a request for the Microsoft Excel 97 form, the form is downloaded to the client, and Microsoft Excel 97 is started. When the user completes the form and clicks Submit, Microsoft Excel submits the data on the form to the database on your Web server. Then, Microsoft Excel closes the form and quits.
REFERENCES
For more information about the internet features, click the Office Assistant, type internet click Search, and then click to view "About Microsoft Excel and the Internet."
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:
120802 Office: How to Add/Remove a Single Office Program or Component
Additional query words: XL97
Keywords: kberrmsg kbprb KB171094