• ▼MSDN Library Visual Studio 6.0
    • ▶Welcome to the MSDN Library
    • ▶Visual Studio Documentation
    • ▶Visual Basic Documentation
    • ▶Visual C++ Documentation
    • ▶Visual FoxPro Documentation
    • ▶Visual InterDev Documentation
    • ▶Visual J++ Documentation
    • ▶Visual SourceSafe Documentation
    • ▶Tools and Technologies
    • ▼Microsoft Office Development
      • ▼Office 97 Documentation
        • ▶Access
        • ▼Excel
          • ▼Microsoft Excel 97 Developer's Kit
            • Excel 97 Developer's Kit
            • ▶Introduction
            • ▶Writing Great Add-Ins
            • ▶Writing Great Wizards
            • ▶Transition Issues
            • ▶Using OLE Automation
            • ▶Using DLLs from Visual Basic
            • ▶Using the OLE 2 IDispatch Interface
            • ▶The Microsoft Excel Applications Programming Interface
            • ▶Applications Programming Interface Function Reference
            • ▼Microsoft Excel File Format
              • File Format Versions
              • ▶The Workbook Compound File
              • Other Microsoft Excel File Formats
              • ▶BIFF Record Information
              • ▼Record Descriptions
                • 1904: 1904 Date System (22h)
                • ADDIN: Workbook Is an Add-in Macro (87h)
                • ADDMENU: Menu Addition (C2h)
                • ARRAY: Array-Entered Formula (221h)
                • AUTOFILTER: AutoFilter Data (9Eh)
                • AUTOFILTERINFO: Drop-Down Arrow Count (9Dh)
                • BACKUP: Save Backup Version of the File (40h)
                • BLANK: Cell Value, Blank Cell (201h)
                • BOF: Beginning of File (809h)
                • BOOKBOOL: Workbook Option Flag (DAh)
                • BOOLERR: Cell Value, Boolean or Error (205h)
                • BOTTOMMARGIN: Bottom Margin Measurement (29h)
                • BOUNDSHEET: Sheet Information (85h)
                • CALCCOUNT: Iteration Count (0Ch)
                • CALCMODE: Calculation Mode (0Dh)
                • CF: Conditional Formatting Conditions (1B1h)
                • CODENAME: VBE Object Name (42h)
                • CODEPAGE: Default Code Page (42h)
                • COLINFO: Column Formatting Information (7Dh)
                • CONDFMT: Conditional Formatting Range Information (1B0h)
                • CONTINUE: Continues Long Records (3Ch)
                • COORDLIST: Polygon Object Vertex Coordinates (A9h)
                • COUNTRY: Default Country and WIN.INI Country (8Ch)
                • CRN: Nonresident Operands (5Ah)
                • DBCELL: Stream Offsets (D7h)
                • DCON: Data Consolidation Information (50h)
                • DCONBIN: Data Consolidation Information (1B5h)
                • DCONNAME: Data Consolidation Named References (52h)
                • DCONREF: Data Consolidation References (51h)
                • DEFAULTROWHEIGHT: Default Row Height (225h)
                • DEFCOLWIDTH: Default Width for Columns (55h)
                • DELMENU: Menu Deletion (C3h)
                • DELTA: Iteration Increment (10h)
                • DIMENSIONS: Cell Table Size (200h)
                • DOCROUTE: Routing Slip Information (B8h)
                • DSF: Double Stream File (161h)
                • DV: Data Validation Criteria (1BEh)
                • DVAL: Data Validation Information (1B2h)
                • EDG: Edition Globals (88h)
                • EOF: End of File (0Ah)
                • EXTERNCOUNT: Number of External References (16h)
                • EXTERNNAME: Externally Referenced Name (223h)
                • EXTERNSHEET: External Reference (17h)
                • EXTSST: Extended Shared String Table (FFh)
                • FILEPASS: File Is Password-Protected (2Fh)
                • FILESHARING: File-Sharing Information (5Bh)
                • FILESHARING2: File-Sharing Information for Shared Lists (1A5h)
                • FILTERMODE: Sheet Contains Filtered List (9Bh)
                • FNGROUPCOUNT: Built-in Function Group Count (9Ch)
                • FNGROUPNAME: Function Group Name (9Ah)
                • FONT: Font Description (231h)
                • FOOTER: Print Footer on Each Page (15h)
                • FORMAT: Number Format (41Eh)
                • FORMULA: Cell Formula (406h)
                • GCW: Global Column-Width Flags (ABh)
                • GRIDSET: State Change of Gridlines Option (82h)
                • GUTS: Size of Row and Column Gutters (80h)
                • HCENTER: Center Between Horizontal Margins (83h)
                • HEADER: Print Header on Each Page (14h)
                • HIDEOBJ: Object Display Options (8Dh)
                • HLINK: Hyperlink (1B8h)
                • HORIZONTALPAGEBREAKS: Explicit Row Page Breaks (1Bh)
                • IMDATA: Image Data (7Fh)
                • INDEX: Index Record (20Bh)
                • INTERFACEEND: End of User Interface Records (E2h)
                • INTERFACEHDR: Beginning of User Interface Records (E1h)
                • ITERATION: Iteration Mode (11h)
                • LABEL: Cell Value, String Constant (204h)
                • LABELSST: Cell Value, String Constant/SST (FDh)
                • LEFTMARGIN: Left Margin Measurement (26h)
                • LHNGRAPH: Named Graph Information (95h)
                • LHRECORD: .WK? File Conversion Information (94h)
                • LPR: Sheet Was Printed Using LINE.PRINT() (98h)
                • MMS: ADDMENU/DELMENU Record Group Count (C1h)
                • MSODRAWING: Microsoft Office Drawing (ECh)
                • MSODRAWINGGROUP: Microsoft Office Drawing Group (EBh)
                • MSODRAWINGSELECTION: Microsoft Office Drawing Selection (EDh)
                • MULBLANK: Multiple Blank Cells (BEh)
                • MULRK: Multiple RK Cells (BDh)
                • NAME: Defined Name (218h)
                • NOTE: Comment Associated with a Cell (1Ch)
                • NUMBER: Cell Value, Floating-Point Number (203h)
                • OBJ: Describes a Graphic Object (5Dh)
                • OBJPROTECT: Objects Are Protected (63h)
                • OBPROJ: Visual Basic Project (D3h)
                • OLESIZE: Size of OLE Object (DEh)
                • PALETTE: Color Palette Definition (92h)
                • PANE: Number of Panes and Their Position (41h)
                • PARAMQRY: Query Parameters (DCh)
                • PASSWORD: Protection Password (13h)
                • PLS: Environment-Specific Print Record (4Dh)
                • PRECISION: Precision (0Eh)
                • PRINTGRIDLINES: Print Gridlines Flag (2Bh)
                • PRINTHEADERS: Print Row/Column Labels (2Ah)
                • PROTECT: Protection Flag (12h)
                • PROT4REV: Shared Workbook Protection Flag (1AFh)
                • PROT4REVPASS: Shared Workbook Protection Password (1BCh)
                • PUB: Publisher (89h)
                • QSI: External Data Range (1ADh)
                • RECIPNAME: Recipient Name (B9h)
                • REFMODE: Reference Mode (0Fh)
                • REFRESHALL: Refresh Flag (1B7h)
                • RIGHTMARGIN: Right Margin Measurement (27h)
                • RK: Cell Value, RK Number (7Eh)
                • ROW: Describes a Row (208h)
                • RSTRING: Cell with Character Formatting (D6h)
                • SAVERECALC: Recalculate Before Save (5Fh)
                • SCENARIO: Scenario Data (AFh)
                • SCENMAN: Scenario Output Data (AEh)
                • SCENPROTECT: Scenario Protection (DDh)
                • SCL: Window Zoom Magnification (A0h)
                • SELECTION: Current Selection (1Dh)
                • SETUP: Page Setup (A1h)
                • SHRFMLA: Shared Formula (BCh)
                • SORT: Sorting Options (90h)
                • SOUND: Sound Note (96h)
                • SST: Shared String Table (FCh)
                • STANDARDWIDTH: Standard Column Width (99h)
                • STRING: String Value of a Formula (207h)
                • STYLE: Style Information (293h)
                • SUB: Subscriber (91h)
                • SUPBOOK: Supporting Workbook (1AEh)
                • SXDB: PivotTable Cache Data (C6h)
                • SXDBEX: PivotTable Cache Data (122h)
                • SXDI: Data Item (C5h)
                • SXEX: PivotTable View Extended Information (F1h)
                • SXEXT: External Source Information (DCh)
                • SXFDBTYPE: SQL Datatype Identifier (1BBh)
                • SXFILT: PivotTable Rule Filter (F2h)
                • SXFMLA: PivotTable Parsed Expression (F9h)
                • SXFORMAT: PivotTable Format Record (FBh)
                • SXFORMULA: PivotTable Formula Record (103h)
                • SXIDSTM: Stream ID (D5h)
                • SXIVD: Row/Column Field IDs (B4h)
                • SXLI: Line Item Array (B5h)
                • SXNAME: PivotTable Name (F6h)
                • SXPAIR: PivotTable Name Pair (F8h)
                • SXPI: Page Item (B6h)
                • SXRULE: PivotTable Rule Data (F0h)
                • SXSELECT: PivotTable Selection Information (F7h)
                • SXSTRING: String (CDh)
                • SXTBL: Multiple Consolidation Source Info (D0h)
                • SXTBPG: Page Item Indexes (D2h)
                • SXTBRGIITM: Page Item Name Count (D1h)
                • SXVD: View Fields (B1h)
                • SXVDEX: Extended PivotTable View Fields (100h)
                • SXVI: View Item (B2h)
                • SXVIEW: View Definition (B0h)
                • SXVS: View Source (E3h)
                • TABID: Sheet Tab Index Array (13Dh)
                • TABIDCONF: Sheet Tab ID of Conflict History (EAh)
                • TABLE: Data Table (236h)
                • TEMPLATE: Workbook Is a Template (60h)
                • TOPMARGIN: Top Margin Measurement (28h)
                • TXO: Text Object (1B6h)
                • UDDESC: Description String for Chart Autoformat (DFh)
                • UNCALCED: Recalculation Status (5Eh)
                • USERBVIEW: Workbook Custom View Settings (1A9h)
                • USERSVIEWBEGIN: Custom View Settings (1AAh)
                • USERSVIEWEND: End of Custom View Records (1ABh)
                • USESELFS: Natural Language Formulas Flag (160h)
                • VCENTER: Center Between Vertical Margins (84h)
                • VERTICALPAGEBREAKS: Explicit Column Page Breaks (1Ah)
                • WINDOW1: Window Information (3Dh)
                • WINDOW2: Sheet Window Information (23Eh)
                • WINDOWPROTECT: Windows Are Protected (19h)
                • WRITEACCESS: Write Access User Name (5Ch)
                • WRITEPROT: Workbook Is Write-Protected (86h)
                • WSBOOL: Additional Workspace Information (81h)
                • XCT: CRN Record Count (59h)
                • XF: Extended Format (E0h)
                • XL5MODIFY: Flag for DSF (162h)
              • Finding Cell Records in BIFF Files
              • ▶Microsoft Excel Formulas
            • ▶Microsoft Excel Chart Records
            • ▶Dynamic Data Exchange and XlTable Format
            • ▶Excel 97 and the Registry
            • ▶Displaying Custom Help
            • Full Code Listing for Wizdemo.xls
            • ▶About the Authors
          • ▶Excel 97 Worksheet Functions Reference
        • ▶Office
        • ▶Project
      • ▶Office 95 Documentation
    • ▶Platform SDK
    • ▶SDK Documentation
    • ▶DDK Documentation
    • ▶Windows Resource Kits
    • ▶Specifications
    • ▶Knowledge Base
    • ▶Technical Articles
    • ▶Backgrounders
    • ▶Books
    • ▶Partial Books
    • ▶Periodicals
    • ▶Conference Papers