>My boss give a problem to solve. It is to find out all the Word and Excel files from the entire harddisk which have password protected.
>So I want to code a program to scan the entire hard disk or code to program to open all the word/excel files.
>Is it possible to code in VFP or Is there any existing scan engine can do that. Would anybody can help me to solve this problem ?
You'll need to recursively search the drive for files matching the extensions of interest, either using ADIR or the Scripting.FileSystemObject to wander through the tree, and once you have the possible files, use the appropriate automation server (Word.Application or Excel.Application in this case) to try to open each file in the list of matching files.
There was a thread a couple of weeks back, take at look at my message
Re: Get a collection of sub folders from a parent folder Thread #
288982 Message #
289075; George Tasker posted code earlier in the threadshowing the ADIR() approach.