Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/170227

From BetaArchive Wiki

Article ID: 170227

Article Last Modified on 10/20/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q170227

SYMPTOMS

When you use the Internet Assistant Wizard in Microsoft Excel 97, some Hypertext Markup Language (HTML) files may appear to be missing.

CAUSE

This problem occurs when you use the Internet Assistant Wizard to:

  • Create an HTML file. -or-


  • Insert the converted data into an existing HTML file.

The problem occurs because the Internet Assistant Wizard uses *.htm as the default file type. This default may cause *.html files to be excluded from the list of files.

WORKAROUND

To work around this problem, use one of the following methods.

Method 1

If you want to insert converted data into an existing HTML file, follow

  1. On the File menu, click Save As HTML.
  2. Make the changes you want in step 1 of the wizard and click Next.
  3. Click "Insert the converted data into an existing HTML file..." and click Next.
  4. Click Browse.
  5. In the File Name box, type *.* and press ENTER.

This forces the "Select your HTML file" dialog box to display all files.

NOTE: The Files Of Type list does not include All Files.

Method 2

If you want to create an independent HTML file with an existing file name (by replacing the existing file), follow these steps:

  1. On the File menu, click Save As HTML.
  2. Make the changes you want in step 1 of the wizard and click Next.
  3. Click "Create an independent, ready to view HTML document..." and click Next.
  4. Make the changes you want in step 3 of the wizard and click Next.


NOTE: In step 4 of the wizard, you can create a new file with the *.html file extension by typing the l at the end of the file path.

  1. Click Browse.
  2. In the File Name box, type *.* and press ENTER.

This forces the "Save your HTML document as" dialog box to display all files.

NOTE: The Save As Type list does not include All Files.

STATUS

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

MORE INFORMATION

For more information about the Internet Assistant Wizard in Microsoft Excel 97 for Windows, please see the following articles in the Microsoft Knowledge Base:

158079 How to Use the Internet Assistant Wizard


168561 How to Programmatically Save a Worksheet as HTML


Keywords: KB170227