Data match with external image data

[ljwmis]

I have a data matching problem as follows;

I have an Excel 2003 spreadsheet containing the details of 1000 members of staff and a separate folder containing .jpg images of the same 1000 members of staff.

How can I match the details of a single department (e.g. 100 members of staff) against the 1000 .jpg images to either a) produce a combined spreadsheet holding the data and correct images or b) to have a departmental spreadsheet containing the 100 staff with a folder containing the 'matched' .jpg images.

The spreadsheet contains the employee number (e.g. 12345678) and the .jpg images are saved as '12345678.jpg' so there is a common identifier.

Thanks for the help!

 

[SkipVought]

Hi,

Macro record inserting any of these images into your sheet.

Post back with your recorded code, if you need help.

Skip,

_[red][/red]

 

[ljwmis]

I've tried to record a macro as you suggest, but because the images are held in a folder outside the Excel 2003 spreadsheet the macro doesn't appear to record.

 

[SkipVought]

I did not know that there were any folders INSIDE Excel.

Exactly what did your try to do that failed.
[r]
Please be PAINFULLY detailed. Be CLEAR, CONCISE & COMPLETE.[/b]

Skip,

_[red][/red]