This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
This article was previously published under Q147273
For a Microsoft Excel 97 version of this article, see
158079 (http://support.microsoft.com/kb/158079/EN-US/).
On This Page
SUMMARY
The Internet Assistant for Microsoft Excel, also known as
the Hypertext Markup Language (HTML) Wizard, is another in a series of add-on
Wizards that Microsoft is making available to enhance your use of Microsoft
Excel. The Internet Assistant for Microsoft Excel helps you to convert Excel
tables into HTML tables in either a separate HTML file or as an insert in an
existing HTML template file.
The add-in that is discussed in this article is provided as-is.
Microsoft does not guarantee that it can be used in all situations. Although
Microsoft Support Professionals can help with the installation and existing
functionality of this add-in, they will not modify the add-in to provide new
functionality.
The Internet Assistant Wizard (HTML Wizard) converts
Microsoft Excel data into a HTML table. This is a great way to get started with
HTML programming because the Wizard does all the work. Below is a detailed
description of each step in the Wizard, followed by an example.
In this step, you specify the range of cells that contain the
data you want to convert. As with most of the Microsoft Excel add-ins, the
dialog box opens with the range box filled in. Microsoft Excel (version 5.0 and
later) is designed to determine where the list is. If the range is not filled
in correctly, you must change it manually either by using the mouse pointer to
select the correct range or by typing the correct range.
Depending on which option you select in step 2 of the wizard, the
information that you must provide in this step varies. Do either of the
following:
•
If you chose the first option in step 2 of the wizard, this
step (step 3) prompts you for the header and footer information. The wizard
does not prompt you to enter anything for the table section because that
information is taken directly from the data.
The Header information
includes the following: title, header, description text, and insertion of a
horizontal line before the table.
The Footer information includes
the following: last update (current date is entered by default), name, e-mail
name, and insertion of a horizontal line after the table.
•
If you chose the second option in step 2 of the wizard,
this step (step 3) prompts you for the path and file name for the HTML template
in which you want the table to be inserted. You can type the path, or you can
browse for it. The HTML template must contain the string "##TABLE##" (without
the quotation marks). The table is inserted into the HTML template after the
string.
NOTE: Before you can use the following example, you must install the
add-in. Please download the file and see the Readme.txt (or IAReadme.txt) file
for installation instructions.
The Microsoft Excel 5.0 or 7.0 add-in
is also available for download from the Microsoft Download Center:
Download Html.exe now (http://download.microsoft.com/download/excel97win/wizard1/1/win98/en-us/html.exe)
The Microsoft Excel for the Macintosh 5.0 or 5.0a add-in is also
available for download from the Microsoft Download Center:
Download Html.hqx now (http://download.microsoft.com/download/excel50mac/wizard/1/MacOS/EN-US/html.hqx)
For
additional information about how to download Microsoft Support files, click the
following article number to view the article in the Microsoft Knowledge Base:
119591 (http://support.microsoft.com/kb/119591/EN-US/) How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most
current virus-detection software that was available on the date that the file
was posted. The file is stored on security-enhanced servers that help to
prevent any unauthorized changes to the file.
On the worksheet, select cell A1. Then, on the Format menu, click AutoFormat.
The AutoFormat dialog box appears.
3.
In the Table Formats list, click Colorful 1. Click OK.
4.
On the Tools menu, click HTML Wizard.
In step 1 of the wizard, the range $A$1:$E$6 appears.
5.
If the range fails to appear, type it. Click Next.
6.
In step 2 of the wizard, click Create an
independent, ready-to-view HTML document that contains your formatted data
(header, table and footer will be created). Click Next.
7.
In step 3, enter the following data:
Title: Company Sales
Header: Department Sales by Region
Last Update: use the current date
Name: type in your name
Email Name: type in your email name (optional)
Click Next.
8.
In step 4 of the wizard, click Convert as much of
the formatting as possible. Click Next.
9.
Type the path and file name to which you want to save the
HTML document. (It defaults to default drive and directory for
Excel\MyHTML.htm.) Click Finish.
NOTE: The file name must have the .htm file name extension.
Need More Help? Contact a Support professional by E-mail, Online or Phone.
Customer Service For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
Newsgroups Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Download Html.exe now (http://download.microsoft.com/download/excel97win/wizard1/1/win98/en-us/html.exe)
Help and Support
Back to the top
