Filesearch for hidden files

[Guest]

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

 

[Norman Jones]

Hi Andy,

There are many reported problems with Filesearch.

See:

http://tinyurl.com/3gwog

 

[NickHK]

Andy,
A lot of people seem to have problems with the Office.Filesearch and its
erratic behaviour.
many advise to drop it use VB/VBA Dir() function instead.

NickHK

 

[Guest]

Thanks Norman (and Nick)

Fixing the problem isn't really an option since the macro will ultimately be
used on mutiple machines - presumably it wasn't fixed in SP2 then?

I guess that leaves me with putting an error trap round the statement that
attempts to open the file if it doesn't exist. I'll also have a go with the
Dir function.

Thanks
Andy