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"

Symptoms

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.

Cause

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 How to recursively search directories by using filesystemobject

Workaround

An alternative solution might be to script the Windows Desktop Search. For more information about this feature, visit the following Microsoft Web site:

http://www.microsoft.com/technet/scriptcenter/topics/desktop/wdsearch.mspx

More Information

Potřebujete další pomoc?

Rozšiřte své znalosti a dovednosti
Projít školení
Získejte nové funkce jako první
Připojit se k programu Microsoft Insider

Byly tyto informace užitečné?

Děkujeme za váš názor!

Děkujeme vám za váš názor! Pravděpodobně bude užitečné, když vás spojíme s některým z našich agentů podpory Office.

×