Microsoft KB Archive/185975

From BetaArchive Wiki
Knowledge Base


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