Leading the way in Microsoft Office Development

What is the Internet Assistant VBA?

The Internet Assistant VBA add-in allows users to publish Excel data to the web.

This add-in was called the Internet Assistant Wizard in Excel 97.

You can convert data in cells directly to HTML either a separate web file or into an existing web file.

To open the Internet Wizard select (File > Save as HTML)

This add-in only works with Excel 97.

Relevant Articles

For more information please refer to the following articles:

Knowledge Base Article (147273)

Knowledge Base Article (150004)

Knowledge Base Article (158079)

Knowledge Base Article (168561)

Knowledge Base Article (234732) - known bug

Internet Assistant Wizard - Update

Step 1 -

Specify the ranges and charts in your workbook that you want to exprot as HTML.

You can also rearrange them to specify the order in which they will appear in your HTMl file.

If you want to include a range of cells that does not appear in the "Ranges and charts to convert" click Add

Step 2 -

Specify whether you want to create an independent ready-to-use HTML file or if you want to insert the HTMl code into an existing HTMl file.

Step 3 -

If you choose to create a new HTMl file then the following are options:

Title

Header

Description below header

Insert a horizontal line before workbook data

Insert a horizontal line after workbook data.

Last update date

By

Email

If you choose to insert the workbook data into an existing HTML file then you are reminded that you must insert the following string into your existing HTML file

You can also specify the path to an existing HTML file.

You must have Frontpage installed on your PC in order to use this option.

Step 4 -

Specify the code page format for your HTML file.

Whether you want to save as a HTML file or as a file in your FrontPage web

Click Finish to save your HTMl file.

Things to Remember

You can obtain the latest version of this Excel add-in from the Microsoft website.