EXTERNNAME: Externally Referenced Name (223h)

The EXTERNNAME record stores an externally referenced name, DDE link, or OLE link. All EXTERNNAME records associated with a supporting workbook must directly follow the EXTERNSHEET record for the workbook. The order of EXTERNNAME records in a BIFF file should not be changed.

External Name

When the EXTERNNAME record stores an external name, fOle and fOleLink are both equal to zero (FALSE), and the record has the form shown in the following table.

Offset

Name

Size

Contents

4

grbit

2

Option flags

6

(Reserved)

4

Reserved; must be 0 (zero)

10

cch

1

Length of the external name

11

rgch

var

External name

var

cce

2

Length of the name definition

var

rgce

var

Name definition, in parsed expression format; for more information, see "Microsoft Excel Formulas" on page 444.


The grbit field contains the option flags listed in the following table.

Bits

Mask

Name

Contents

0

0001h

fBuiltin

= 1 if the name is a built-in name

1

0002h

fWantAdvise

N/A for External Names (must be 0 (zero))

2

0004h

fWantPict

N/A for External Names (must be 0 (zero))

3

0008h

fOle

N/A for External Names (must be 0 (zero))

4

0010h

fOleLink

N/A for External Names (must be 0 (zero))

15 – 5

FFE0h

(reserved)

Reserved; must be 0 (zero)


DDE Link

When the EXTERNNAME record stores a DDE link, the record has the form shown in the following table.

Offset

Name

Size

Contents

4

grbit

2

Option flags

6

(Reserved)

4

Reserved; must be 0 (zero)

10

cch

1

Length of the external name

11

rgch

var

External name

var

rgoper

var

Array of OPERs that stores the current value of the name


The grbit field contains the option flags listed in the following table.

Bits

Mask

Name

Contents

0

0001h

fBuiltin

N/A for DDE links (must be 0 (zero))

1

0002h

fWantAdvise

= 0 for manual DDE links
= 1 for automatic DDE links

2

0004h

fWantPict

= 1 if Microsoft Excel wants a cfPict clipboard format representation of the data; OBJ and IMDATA records store the image

3

0008h

fOle

= 1 if this record stores the OLE StdDocumentName identifier (no rgoper follows rgch)

4

0010h

fOleLink

= 0 for DDE links

14 – 5

7FE0h

cf

The clipboard format for which the DDE Advise succeeded; this is used to reduce the time required for future Advise cycles

15

8000h

(Reserved)

Reserved; must be 0 (zero)


OLE Link

When the EXTERNNAME record stores an OLE link, fWantAdvise and fOleLink are equal to 1 (TRUE), and the record has the form shown in the following table.

Offset

Name

Size

Contents

4

grbit

2

Option flags

6

lStgName

4

OLE 2 storage identifier

10

cch

1

Length of the link name

11

rgch

var

Link name


The grbit field contains the option flags listed in the following table.

Bits

Mask

Name

Contents

0

0001h

fBuiltin

N/A for OLE links (must be 0 (zero))

1

0002h

fWantAdvise

= 0 for manual OLE links
= 1 for automatic OLE links

2

0004h

fWantPict

= 1 if Microsoft Excel wants a cfPict clipboard format representation of the data; OBJ and IMDATA records store the image

3

0008h

fOle

N/A for OLE links (must be 0 (zero))

4

0010h

fOleLink

= 1 for OLE links

15 – 5

FFE0h

(Reserved)

Reserved; must be 0 (zero)