With Application.FileSearch for Excel 2010

[cbdu]

Hello experts,

I need a help with macro modification. I have one macro not working - attach. 1.
Its not runing because of Filesearch function is used for Excel before ver.2007, and I need to modify it to Excel after 2007.
On other hand I've found another macro - attach.2 which is working but not doing properly everything I want. I set this macro 2 as a class module called
rfgFileSearch
which actually has a referance in macro 1 as you can see.

The problem is I am not able to modify macro 2 "to do " exactly same work as macro 1.

Can someone take a look in both codes and try to modify macro 2? Or just modify macro 1 for Excel>=2007.

Any help is critical for me. Thanks a lot.

CB

[royUK]

See this

http://excel-it.com/Excel%202007/2007_filesearch.htm

[cbdu]

Hey,
Thanks , however its not solving my issue. This is a funadamental structure of search function replacement.

Dear Experts, Can someone check my procedure in macro and help me to modify it, please?

Thank you in advance. Hava a fruitfull day

[royUK]

I don't understand, you can't use Filesearch in Excel 2007 onwards, so you need to change the code using the example as a base