Application.FileSearch doesn’t work in Excel 2010?

Asked By Gregory Swisher 70 points N/A Posted on - 08/16/2012

Trying to use the file search in the Office 2007, hence it doesn't work also Office 2010 also.

A run-time error 445 Object doesn't support this action..

Run-time error '445': Object doesn't support this action.

• Status: Open
• Question Views: 1965
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by arsalankhan121

Go To Solution

Answered By Hathy greave 0 points N/A #140170

Application.FileSearch doesn’t work in Excel 2010?

Hi,

Office 2007 and 2010 VBA don't support Application.FileSearch more. It's quite surprising but true that the application has been removed from Office 2007 and 2010 and it has been done without any replacement. 

So, you will have to use the Scripting FileSystemObject for that. 

Cheers

Hathy

About Hathy greave

Questions
2

Answers
147

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/16/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By arsalankhan121 0 points N/A #140171

Application.FileSearch doesn’t work in Excel 2010?

Hello Gregory !

A file search option has been removed from Ms Office 2007 and Ms office 2010. You can use Old Dir as an alternate. For more information about the Dir function visit this site 

• https://support.office.com/en-us/article/Dir-Function-1a1a4275-f92f-4ae4-8b87-41e4513bba2e?CorrelationId=f6c7b152-a6e7-4b72-a5a4-60051c6661bd&ui=en-US&rs=en-US&ad=US&ocmsassetID=HA001228824

For search you have to pass in the file path .

Enjoy

Arsalan

About arsalankhan121

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 11/29/2012
• Question Category: MS Excel