Article ID: 185975
Article Last Modified on 11/13/2003
APPLIES TO
- Microsoft Excel 98 for Macintosh
- Microsoft PowerPoint 98 for Macintosh
- Microsoft Word 98 for Macintosh
This article was previously published under Q185975
SYMPTOMS
When you create a procedure that uses the FileFind method in Visual Basic for Applications, all files are returned.
CAUSE
This problem occurs when the following conditions are true:
- You specify a value of msoFileTypeBinders for the FileType argument of the FileFind method. -or-
- You specify a value of msoFileTypeDatabases for the FileType argument of the FileFind method.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
MORE INFORMATION
Although they are listed separately in the Help topic for the FileType property, the built-in constants msoFileTypeBinders and msoFileTypeDatabases return the same results as the msoFileTypeAllFiles when you use them with the Microsoft products that are listed at the beginning of this article.
NOTE: These FileTypes are used in Visual Basic for Applications in the Microsoft Office 97 for Windows programs.
REFERENCES
For more information about the FileType property, from the Visual Basic Editor, click the Office Assistant, type filetype click Search, and then click to view "FileType Property."
For more information about Constants, from the Visual Basic Editor, click the Office Assistant, type constants click Search, and then click to view "Using Constants."
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If the Assistant is not able to answer your query, please see the following article in the Microsoft Knowledge Base:
176476 OFF: Office Assistant Not Answering Visual Basic Questions
Additional query words: XL98 OFF98 wd98
Keywords: kbbug kbnofix KB185975