Page 310 - Microsoft Office Excel 2003 Programming Inside Out
P. 310
Microsoft Office Excel 2003 Programming Inside Out
Table 13-2. List of File Types and Their Values (continued)
msoFileType Constants Value
msoFileTypeTemplates 8
msoFileTypeOutlookItems 9
Chapter 13
msoFileTypeMailItem 10
msoFileTypeCalendarItem 11
msoFileTypeContactItem 12
msoFileTypeNoteItem 13
msoFileTypeJournalItem 14
msoFileTypeTaskItem 15
msoFileTypePhotoDrawFiles 16
msoFileTypeDataConnectionFiles 17
msoFileTypePublisherFiles 18
msoFileTypeProjectFiles 19
msoFileTypeDocumentImagingFiles 20
msoFileTypeVisioFiles 21
msoFileTypeDesignerFiles 22
msoFileTypeWebPages 23
The LastModified property can use the following constants listed in Table 13-3.
Table 13-3. List of LastModified Properties and Their Values
msoLastModified Constants Value
msoLastModifiedYesterday
1
msoLastModifiedToday
2
msoLastModifiedLastWeek
3
msoLastModifiedThisWeek
4
msoLastModifiedLastMonth
5
msoLastModifiedThisMonth
6
msoLastModifiedAnyTime
7
Instead of using the FileType property, you can specify the FileName property.
.FileName = “*.xls”
284
Part 4: Advanced VBA
