Convert 2003 macro to work with 2007

[luckyros]

Please Login or Register  to view this content.

Can anyone help me to run this code in Excel 2007 ? This code is working fine in MS Excel -2003. But when i run it in Excel 3007 it gives error stating ""Run-time error '445': Object doesn't support this action". when i press debug its comes on here "With Application.FileSearch" which is marked yellow. Excel 2007 doent support this function.

Can anyone help me regarding this ?? What i actually want to do with code is posted in the forum. the link is

http://www.excelforum.com/excel-prog...workbooks.html

[royUK]

There is no Filesearch in Excel 2007, see

http://www.excel-it.com/Excel%202007...filesearch.htm