Excel 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 can I dynamically add series to an existing chart using VBA?

2) How do I update my DropDown list whenever the sheet is activated?

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

4) How to center excel sheet horizontally and verticaly on page in Excel

5) How can I get users to select a file for processing using my macro?

6) How can I list all files in a folder using VBA?

7) Determine if hyperlinks are valid in Excel

8) How can I dynamically add a hyperlink using VBA?

9) How can I change the Marker size and Marker line color for all the series in a chart?

10) How can I export a WorkSheet as a PDF using VBA?

11) How can I set FreezePanes in a certain range using VBA?

12) How can I set non-contiguous print area using VBA?

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

14) How do I restrict user entry in ActiveX Text Box to just numeric values?

15) How can I get input from user through a prompt and assign user's input to a cell?