Microsoft Office Tutorials and References
In Depth Information
Table 13-2. List of File Types and Their Values (continued)
msoFileType Constants
Value
msoFileTypeTemplates
8
msoFileTypeOutlookItems
9
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
msoLastModifiedToday
msoLastModifiedLastWeek
msoLastModifiedThisWeek
msoLastModifiedLastMonth
msoLastModifiedThisMonth
msoLastModifiedAnyTime
1
2
3
4
5
6
7
Instead of using the FileType property, you can specify the FileName property.
.FileName = “*.xls”
Search JabSto ::




Custom Search