xl2007 Application.FileSearch

[OssieMac]

Can anyone tell me what has changed with Application.FileSearch in xl2007. It
worked perfectly in earlier versions but now I get an error message:-

Runtime error '445'

Object doesn't support this action.

Have looked at 'what's new' in help and it tells me that filesearch is
hidden. However it doesn't tell me how to access it or do they really mean
that it is no longer available?

Thanks in anticipation of your help

OssieMac

 

[NickHK]

I understood MS removed .FileSearch from Office 2007, possibly because it
never seemed to be reliable in previous versions.
Use the standard VBA Dir() or one of the numerous classes/addin/file
listings available.

Here are some:
http://www.google.co.uk/search?hl=en&q=excel+list+files&btnG=Google+Search&meta=

NickHK

 

[OssieMac]

Thanks for the info. If they have removed it, I really don't know why they
can't say that in help instead of saying it is hidden. I spent forever
searching the help to see exactly what they meant by hidden because the usual
meaning is that if something is hidden then there is a way to unhide it.

To anyone who reads this I am interested in finding a microsoft site where
we can provide feedback about the stuff in (and NOT in) their software that
we are not satisfied with. Afterall one has to consider we have been sold a
lemon when xl2007 is supposed to be an upgrade and they have actually taken
functionality out of it. I recently found out that a lot of the macro
recording for charts has also disappeared.

Regards and thanks again Nick for your help

OssieMac

 

[NickHK]

Personally I have found no compelling reason to use XL2007 at the moment,
although I'm sure those people who <need> 1 million+ rows and 16K+ columns
instead of using a DBMS are more than happy with the speed, charting,
etc...<g>

NickHK