troubleshooting Question

Application.FileSearch does not work in excel 2016

Avatar of Flora Edwards
Flora EdwardsFlag for Sweden asked on
Microsoft ExcelVBA
2 Comments1 Solution1495 ViewsLast Modified:
I inherited some files from excel 2007 which no longer works, as i see application.filesearch 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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros