<div>
<div class="content wysiwyg-content">
I inherited some files from excel 2007 which no longer works, as i see <a href="https://msdn.microsoft.com/en-us/library/office/aa219847(v=office.11).aspx" rel="ugc">application.filesearch</a> was used.<br />
<br />
sorry, cannot share the files here.<br />
<br />
i searched alot and got even more confused on which option is the best to replace the outdated application.filesearch<br />
<br />
some people say, dir is the option to use, but it does not work in sub folder.<br />
<br />
downloaded <a href="http://dfenton.com/DFA/download/Access/FileSearch.zip" rel="ugc">http://dfenton.com/DFA/download/Access/FileSearch.zip</a>&nbsp; which is in access, but i cannot put it on use, it is in access and when i open it, it gives me 64bit access require PtrSafe<br />
<a href="http://dl.dropbox.com/u/35239054/FileSearch.cls" rel="ugc">http://dl.dropbox.com/u/35239054/FileSearch.cls</a>&nbsp; &nbsp;i do not know how to use this by Andreas Killer<br />
<br />
<a href="http://bettersolutions.com/vba/files-directories/filesearch.htm" rel="ugc">http://bettersolutions.com/vba/files-directories/filesearch.htm</a>&nbsp; &nbsp;also some toturials but could not get my head around it.<br />
<br />
<a href="http://www.codematic.net/excel-tools/office-2007-filesearch.htm" rel="ugc">http://www.codematic.net/excel-tools/office-2007-filesearch.htm</a>&nbsp; explains but has broken link<br />
<br />
is there any class that i import in my file and it would just work exactly as the old one? or what is the best alternative solution to this?
</div>
</div>


I inherited some files from excel 2007 which no longer works, as i see application.filesearch (https://msdn.microsoft.com/en-us/library/office/aa219847(v=office.11).aspx) was used.

sorry, cannot share the files here.

i searched alot and got even more confused on which option is the best to replace the outdated application.filesearch

some people say, dir is the option to use, but it does not work in sub folder.

downloaded http://dfenton.com/DFA/download/Access/FileSearch.zip  which is in access, but i cannot put it on use, it is in access and when i open it, it gives me 64bit access require PtrSafe
http://dl.dropbox.com/u/35239054/FileSearch.cls   i do not know how to use this by Andreas Killer

http://bettersolutions.com/vba/files-directories/filesearch.htm   also some toturials but could not get my head around it.

http://www.codematic.net/excel-tools/office-2007-filesearch.htm  explains but has broken link

is there any class that i import in my file and it would just work exactly as the old one? or what is the best alternative solution to this?

Application.FileSearch does not work in excel 2016

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.