Filesearch for hidden files
Hi all
As part of a macro I have written, I am doing a filesearch to check that a
template file exists before trying to open it. However, I cannot get it to
work in that it always returns 0. I have tried finding files other than the
one I want and it seems to work fine so I know my code is OK. This led me to
conclude that there must be soehting about this particular file so I re-ran
the code from the root (C:\) gradually adding directories for my chosen path
each time to try and work out where the problem was. The code stopped
finding files after I added a directory which I discovered was hidden. Am I
correct in assuming that the filesearch class does not search hidden
directories/files and if so is there any way of getting it to do so? There
doesn't seem to be anything relating to this in the Excel Help files.
Thanks
Andy
|