Microsoft KB Archive/177196

= Run-Time Error 1004 Appears When Saving File in HTML Format =

Article ID: 177196

Article Last Modified on 8/19/2003

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q177196



SYMPTOMS
In the versions of Microsoft Excel listed at the beginning of this article, if you run the Internet Assistant Wizard by clicking Save As HTML on the File menu and click Finish in step 4 of the wizard, you may receive the following error message:

Run-time error '1004':

The formula you typed contains an error.

- For information about fixing common formula problems, click Help.

- To get assistance entering a function, click OK, then click Function on the Insert menu.

- If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark (').

When you receive this error message, the Internet Assistant Wizard stops running.



CAUSE
This problem occurs if, in step 3 of the wizard, you enter a quotation mark (") in any of the following boxes:

Title

Header

Description below header

Last Update on

By

Email

For example, if you enter The HTML Wizard in the By box, the problem occurs.



RESOLUTION
To resolve this problem, do not enter any quotation marks in step 3 of the wizard. If you want quotation marks to appear in the Hypertext Markup Language (HTML) file, manually edit the HTML file after you save it in Microsoft Excel.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.



MORE INFORMATION
In Microsoft Excel, you can use the Internet Assistant Wizard to save the contents of a worksheet as a new HTML file or as a table in an existing HTML file.

Additional query words: XL97 XL

Keywords: kberrmsg kbprb KB177196

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.