XL97: Internet Assistant Wizard Doesn't Recognize All Files

 Last reviewed: January 9, 1998
Article ID: Q170227
The information in this article applies to:
  • Microsoft Excel 97 for Windows

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 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 "Insert the converted data into an existing HTML file..." and click Next.

  4. Click Browse.

  5. In the File Name box, type "*.*" (without the quotation marks) 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" (without the quotation marks) at the end of the file path.

  5. Click Browse.

  6. In the File Name box, type "*.*" (without the quotation marks) 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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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: 

   ARTICLE-ID: Q158079
   TITLE     : XL97: How to Use the Internet Assistant Wizard

   ARTICLE-ID: Q168561
   TITLE     : XL97: How to Programmatically Save a Worksheet as HTML

Additional query words:
Version : WINDOWS:97
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 9, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.