Can anyone help?? I'm trying to write a fairly complex macro in Excel which can go through and find all the files in a specified directory, I've done Word, Excel and Powerpoint, the only thing is when I try to do it for Project it says the the .FileSearch property is not supported. Weird or what?
Any ideas or does anyone know if there is a later Porject refence library that I could use?
Wed, 16 Jul 2003 05:46:27 GMT
Venkata Krishn #2 / 2
Referencing Proj 98 in Excel 97 VBA
Leyton
FileSearch property of Application object was introduced in Project 2000. It does not exist in MS Project 98.
My be you can use FileSearch object of MS Office object library instead.
Regards Venkata Krishna
Quote:
> Can anyone help?? > I'm trying to write a fairly complex macro in Excel which can go through and > find all the files in a specified directory, I've done Word, Excel and > Powerpoint, the only thing is when I try to do it for Project it says the > the .FileSearch property is not supported. Weird or what?
> Any ideas or does anyone know if there is a later Porject refence library > that I could use?
Referencing Proj 98 in Excel 97 VBA