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.
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
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
