Searching For Multiple Files using VB

[rossmcl]

Hi

I want to search for certain files on a mail exchange using VB. ie so I can pull up ALL pst's that contain word *smith or whatever - I dont want to just find the first one - and stick their full names in a list.

Anyone got the code for this?

Thanks

 

[RobertP]

MyPath = "c:\exchange\*smith*.pst"
MyName = Dir(MyPath)
Do While MyName <> &quot;&quot; ' Start the loop.
Debug.Print MyName ' Add to your list here
MyName = Dir ' Get next entry.
Loop

Hope this helps,

Rob.