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.
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) |
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 |
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) |
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 |
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) |