File Search and Insert using VBA

Question

I am looking for a simple way to search for a file named the same thing as a variable that I have already determined and then insert that file into an excel file.  I have tried to use the application.filesearch, but I have not been able to get this string to actually display or insert the files it has found.

Answer 1

I'm using excel 2003 by the way.

Answer 2

I think I've got it with ActiveSheet.Pictures.Insert(.FoundFiles(i) and the application.filesearch application.  Thanks to all who have viewed this.