Microsoft KB Archive/49274

From BetaArchive Wiki


Excel Err Msg: "Cannot Load That Help File" with Custom Help

Last reviewed: November 2, 1994
Article ID: Q49274

SUMMARY

The error message "Cannot Load That Help file" can appear when you call a custom Help file created within Excel version 2.20.

If the Help file was created within Excel with comment text and then saved as TEXT, it cannot be read as a Help file. Thus, the following format cannot be used if the file is created from within Excel and saved as TEXT:

   *topic_number,comment text
   One or more lines of text
               .
               .
               .

This problem occurs because Excel places quotation marks around any cell that contains a comma (,). Thus, the first line of the Help topic containing the asterisk (*) and the topic number are not recognized by Excel as a valid Help file topic line. Excel encloses cells containing commas with quotation marks so that they can be read correctly by applications expecting commas as record delimiters. When creating a Help file in Excel, the first cell should contain only an asterisk followed by a topic number. Comments can be added in the adjacent cell to the right, with no comma.

Alternatively, you can create the Excel Help file in any word-processing application that can export straight ASCII text files.


KBCategory: kbother

KBSubcategory:

Additional reference words: 2.20


Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.