Search containing folder for filenames and display value in cell.

[theRDstore]

I have a spreadsheet and each line is a different product. Each product has a Model number, description, attributes etc. There is also a cell for "picture name".

The picture name is the model number with .jpg after it.

I need to fill in this cell automatically. A simple concatenate formula will not work because I Only want to display the picture name, if the picture exists. If the picture exists, I want to display the filename in the cell, if it doesnt, I want to leave it blank.

Can anyone show me how to do this? The Spreadsheet is in the same folder as the Pictures. There is over 3000 of them.

Any Help?

James

[Leith Ross]

Hello James,

It would help to see a sample of your worksheet layout or at least a description of which columns contain the model number, description, etc.

[Kafrin]

You need to use the Application.FileSearch function. Try something like this:

Please Login or Register  to view this content.