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

Hi Andy,

There are many reported problems with Filesearch.

See:

http://tinyurl.com/3gwog


---
Regards,
Norman



"Andy" wrote in message
...
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

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

"Andy" wrote in message
...
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

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

"Norman Jones" wrote:

Hi Andy,

There are many reported problems with Filesearch.

See:

http://tinyurl.com/3gwog


---
Regards,
Norman



"Andy" wrote in message
...
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