OFF98: FileFind Method Returns All Files

ID: Q185975

The information in this article applies to:

• Microsoft Excel 98 Macintosh Edition
• Microsoft PowerPoint 98 Macintosh Edition
• Microsoft Word 98 Macintosh Edition

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:

   ARTICLE-ID: Q176476
   TITLE     : OFF: Office Assistant Not Answering Visual Basic Questions

Keywords          : kbdta xlvbainfo OffVBA 
Version           : MACINTOSH:98
Platform          : MACINTOSH
Issue type        : kbbug
Solution Type     : kbnofix

Last Reviewed: May 22, 1998