I wrote some VBA code in a workbook which will search a computers hard drive for .xls and .doc files and report the number and location of each file.
This is being used for audit purposes and I want it to be as easy to run as possible. I have a sheet that reports with two buttons on it and that's all the user has to do is click a button and wait.
Now, if folders or files are hidden, the file search will not search in them. Is there a way in Excel to specify to search for hidden files as well? I have searched around but I haven't found anything.
I know there is the SetAttr function which I could use to hide/unhide folders but the idea of the audit is that someone may hide a folder that I don't know to unhide so that won't work.
Any suggestions are welcome.