2010 vba replacement of application filesearch in Excel


First off I am a noob at VBA and I have been trying to fix this issue myself by reading other threads. Sucks Application.Filesearch is gone, I could at least figure that coding out. It is not going very well. The following code is pasted below. If somebody is kind enough to please provide me a solution for this code. Many thanks in advance!!!


Indeed the function Application.Filesearch is gone. You can find a custom replacement function under the following link.

 Other excel answers



You can find similar Excel Questions and Answer hereunder

1) How to code more simply in VBA. Use of Keywords is helping a lot

2) How can I remove display of Gridlines in my worksheet using VBA?

3) How do I enter a formula in a cell using VBA (using Relative Reference)?

4) How can I avoid updates to cell values during macro execution?

5) How can I extract file name from a full path including folder path and file name?

6) How can I find the number of working days between 2 dates using VBA?

7) How can I copy and rename a WorkSheet using VBA?

8) The name manager in Excel is very useful to keep an overview and manage all the variable names in Excel. Here how to use the name manager in VBA

9) Write to text file without quotes in vba in Excel

10) How do I assign a macro to a shape using VBA?


Here the previous and next chapter