Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 920229 - Last Review: February 18, 2008 - Revision: 2.0
Error message when you run a macro to search for a file in an Office 2007 program: "Run-time error 5111"
You run a Microsoft Visual Basic for Applications (VBA) macro in a Microsoft Office 2007 program to search for a file on your computer. When you do this, you may receive the following VBA error message:
"Run-time error 5111
The command is not available on this platform"
This issue occurs when you have 2007 Office programs installed on a Microsoft Windows XP computer, and the VBA macro uses the
Application.FileSearch object. This object is no longer supported in 2007 Office programs.
To work around this issue, use the FileSystemObject object to recursively search directories and to find specific files. See the sample code that is provided in the following Microsoft Knowledge Base article:
185601Â
(http://kbalertz.com/Feedback.aspx?kbNumber=185601/
)
How to recursively search directories by using filesystemobject
An alternative solution might be to script the Windows Desktop Search. For more information about this feature, visit the following Microsoft Web site:
APPLIES TO
- Microsoft Office Access 2007
- Microsoft Office Excel 2007
- Microsoft Office PowerPoint 2007
- Microsoft Office Visio Professional 2007
- Microsoft Office Visio Standard 2007
- Microsoft Office Word 2007
| kberrmsg kbtshoot kbprogramming kbautomation kbprb kbexpertiseinter kbexpertisebeginner KB920229 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate