Microsoft KB Archive/249888

From BetaArchive Wiki
Knowledge Base


XL2000: "Insert Into Existing HTML File" Option Is Missing

Article ID: 249888

Article Last Modified on 11/5/2003



APPLIES TO

  • Microsoft Excel 2000 Standard Edition



This article was previously published under Q249888

SYMPTOMS

In Microsoft Excel 2000, you may be unable to insert data into an existing Hypertext Markup Language (HTML) document. Although Excel 97 offers the option Insert the converted data into an existing HTML file (just the table will be created), this option appears to be missing in Excel 2000.

CAUSE

The Excel 97 Insert the converted data into an existing HTML file (just the table will be created) option does not exist in Microsoft Excel 2000.

WORKAROUND

To work around this issue, follow these steps:

  1. Use a Web browser or a text editor to edit the source code of the existing HTML Web page. To do so, follow these steps:
    1. Start Microsoft Internet Explorer.
    2. On the File menu, click Open.
    3. In the Open box, select the HTML file that you want, and then click OK.
    4. In the Internet Explorer window, right-click the HTML document that you opened.
    5. On the shortcut menu, click View Source. Notice that the HTML document source code is displayed in Notepad or WordPad.

  2. In the document window, insert a new blank line at the location that you want the Excel data to appear.
  3. On the new blank line, type the following data:

  4. On the File menu, click Save, and then close the text editor.
  5. Click to select Internet Explorer.
  6. On the File menu, click Save As.
  7. In the File name box, type the name that you want your file to be saved as, and then click OK.
  8. Quit Internet Explorer.
  9. Start Excel 2000 and open the workbook that contains the selection that you want to add to the HTML document.
  10. On the worksheet, select the cells that you want to add to the HTML document.
  11. On the File menu, click Save As Web Page.
  12. In the File name box, type the same name that you used in step 7, click to select Selection:$x$x:$x$x, and then click Save.
  13. Click Add to file, and then quit Excel 2000.
  14. Start Internet Explorer, and then open your HTML document.

Notice that your Excel 2000 selection appears in your document at the location that you specified.

REFERENCES

For more information about placing Excel data on a Web page, click Microsoft Excel Help on the Help menu, type web page in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.



Additional query words: XL2000

Keywords: kbprb KB249888