Microsoft KB Archive/51568

Word Err Msg: Microsoft Excel Area Reference Is Missing

PSS ID Number: Q51568 Article last modified on 03-07-1997

=
========================================================= 4.00 MACINTOSH kbusage kberrmsg

= SUMMARY =

The identifier paragraph for a Microsoft Excel worksheet selection must specify the Microsoft Excel worksheet area following the filename. The named Microsoft Excel worksheet area or the range of rows and columns (in R1C1 format) must follow the Excel source-file name and must be separated from the filename by an exclamation point. For example, if cells A1:A2 of a worksheet named “TEST” are Paste Linked into Word, the identifier paragraph will say the following:

Excel! TEST!R1C1:R2C1 ( refers to the entire path name of the file.)

If the range of A1:A2 is named “Total”, the identifier paragraph will say the following:

Excel!TEST!Total

= MORE INFORMATION =

For information on the identifier paragraph format, see the “Paste Link Command” section in the “Reference to Microsoft Word” manual.

For a complete list of possible error messages while using the Link commands, refer to the “Reference to Microsoft Word” manual, Appendix C, pages 412-414.

KBCategory: kbusage kberrmsg KBSubCategory: Additional reference words: macword macword5

= ====================================================================== =

Copyright Microsoft Corporation 1997.