Vba And Excel Object Model Quick Reference

EXCEL OBJECT MODEL CONSTANTS (CONTINUED)

XlFileFormat Constants (Continued)

CONSTANT

VALUE

DESCRIPTION

xlCSVMSDOS

24

MSDOS comma-separated values format.

xlCSVWindows

23

MS Windows comma-separated values format.

xlCurrentPlatformText

-4158

Text file based on current operating system.

xlDBF2

7

DBase II format.

xlDBF3

8

DBase III format.

xlDBF4

11

DBase IV format.

xlDIF

9

Data interchange format.

xlExcel2

16

Excel 2.0 format.

xlExcel2FarEast

27

Excel 2.0 format - Far East version.

xlExcel3

29

Excel 3.0 format.

xlExcel4

33

Excel 4.0 format.

xlExcel4Workbook

35

Excel 4.0 workbook format.

xlExcel5

39

Excel 5.0 format.

xlExcel7

39

Excel 97 format.

xlExcel9795

43

Excel 95 - 97 format.

xlHtml

44

HTML format.

xlIntlAddIn

26

Excel international Add-in.

xlIntlMacro

25

Excel international macro.

xlSYLK

2

Symbolic link format.

xlTemplate

17

Template file format.

xlTextMac

19

Macintosh text file format.

xlTextMSDOS

21

MSDOS text file format.

xlTextPrinter

36

Text file created for a printer (.prn).

xlTextWindows

20

MS Window text file format.

xlUnicodeText

42

Unicode text file format.

xlWebArchive

45

Web archive format (.mht).

xlWK1

5

Lotus 2.x format.

xlWK1ALL

31

Lotus 2.x .all format.

VBA QUICK REFERENCE

EXCEL OBJECT MODEL CONSTANTS (CONTINUED)

XlFileFormat Constants (Continued)

CONSTANT

VALUE

DESCRIPTION

xlWK1FMT

30

Lotus 2.x .fmt format.

xlWK3

15

Lotus 3.x format.

xlWK3FM3

32

Lotus 3.x and Lotus 1-2-3 for Windows format.

xlWK4

38

Lotus 4.0 format.

xlWKS

4

MS Works file format.

xlWorkbookNormal

-4143

Excel workbook format.

xlWorks2FarEast

28

MS Works file - Far East format.

xlWQ1

34

Quattro Pro for MSDOS format.

xlXMLSpreadsheet

46

XML format.

MsoFileType Constants

CONSTANT

VALUE

DESCRIPTION

msoFileTypeAllFiles

1

All file types.

msoFileTypeBinders

6

Microsoft Office Binder file.

msoFileTypeCalendarItem

11

Microsoft Outlook Calendar item.

msoFileTypeContactItem

12

Microsoft Outlook Contact item.

msoFileTypeDatabases

7

Database files.

msoFileTypeDataConnectionFiles

17

Database connection files.

msoFileTypeDesignerFiles

22

Designer files.

msoFileTypeDocumentImagingFiles

20

Document imaging files.

msoFileTypeExcelWorkbooks

4

Microsoft Excel Workbooks.

msoFileTypeJournalItem

14

Journal items.

msoFileTypeMailItem

10

Microsoft Outlook Mail message.

msoFileTypeNoteItem

13

Microsoft Outlook Note item.

msoFileTypeOfficeFiles

2

All Microsoft Office file types.

msoFileTypeOutlookItems

9

Microsoft Outlook files.

msoFileTypePhotoDrawFiles

16

Microsoft PhotoDraw files.

msoFileTypePowerPointPresentations

5

Microsoft PowerPoint files.

msoFileTypeProjectFiles

19

Microsoft Project files.

msoFileTypePublisherFiles

18

Microsoft Publisher files.

msoFileTypeTaskItem

15

Microsoft Outlook Task item.

msoFileTypeTemplates

8

Template files.

0 0

Post a comment