Expert Needed

[jnc]

I am trying to write an application which will find all of the excel
workbooks on our network and was looking for some ideas as to how to
go about this.

I guess there are going to be some security issues around this, any
help / pointers would be greatly appreaciated.

Cheers.....Jim

 

[Michael Giagnocavo [MVP]]

Well, to find *all* workbooks, you'd need to have something that has
access to at least read the directory list of every directory on every
machine.

You might want to look into the Microsoft Indexing Service. It can
run in a background process, and will index all files. I think it
even indexes some Excel fields (like author, dates, etc.). In MSDN
you can find details of how to query the indexing service.

-mike
MVP