Finding Files Using VBA

[manrav]

Is there a way to find out which drive and directory a particular file is in. I would like to be able to do this through VBA. All I need is to be able to capture the drive letter and the folder that a particular file is in and save it.
Any Ideas.....?

 

[PaddyD]

try filesearch...

Paddy

 

[manrav]

Thanks Paddy,
But how do I get it to search for the file using multiple drives. Can I search for the file in drives c:,D,and F at the same time?

Also I don't need to open the file I just need to be able to store the Drive Letter and path as string.

Any Help Greatly appreciated..
Thanks..

 

[PaddyD]

any file, or are you looking to return the addres of the current file?

Paddy