Application.FileSearch doesn’t work in Excel 2010?

Asked By 70 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by arsalankhan121
Answered By 0 points N/A #140170

Application.FileSearch doesn’t work in Excel 2010?

qa-featured

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

Best Answer
Best Answer
Answered By 0 points N/A #140171

Application.FileSearch doesn’t work in Excel 2010?

qa-featured

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 

For search you have to pass in the file path .

Enjoy

Arsalan

Login/Register to Answer

Related Questions