Microsoft KB Archive/69264

The Excel 3.00 EMBED Function PSS ID Number: Q69264 Article last modified on 02-26-1993 PSS database name: W_eXceL

3.00

WINDOWS

Summary:

The Microsoft Excel 3.0 and 4.0 EMBED function is used to indicate when the object selected in Excel is an embedded object. The Microsoft Excel Function Reference&quot; version 3.0’s description of the function on page 67 doesn’t include the mandatory second argument to the function.

This documentation error does not occur in Excel version 4.0.

The syntax for the EMBED function should read:

=EMBED(object_type,item)

The object type specifies the application and document type that created the embedded object. The second argument describes the item in the document that is embedded. If the object_type is “ExcelChart”, the item will always be “Chart”. If the object_type is “ExcelWorksheet”, the item will be an R1C1 format reference that designates the active cells in the embedded worksheet. For example:

=EMBED(“ExcelChart”,“Chart”)

-or-

=EMBED(“ExcelWorksheet”,“R1C1:R10C15”)

The item argument will be dependent on the object_type, and the object-type dependent upon the embedding server application. The above examples are for embedded charts and worksheets from Excel 3.00.

Reference(s):

“Microsoft Excel Function Reference.” Version 3.00, page 67.

“Microsoft Excel User’s Guide.” Version 3.00, pages 325-327.

Copyright Microsoft Corporation 1993.