SYNCRONIZING PICTURES WITH EXCEL DATA

[mrudangr]

I want to make identity card for student, where in the pictures of student come with details pertaining to name, address, age, class etc. Now i have details of students in excel worksheet & pictures of the student in different folder. Now i want to syncronize that folder with the excel worksheet so that i need not to insert pic of every student in worksheet. Pls let me know can i do this in Excel ?

I shall be very thankfull to you.

 

[Luke M]

Do the pictures have a good naming convention (name of student, serial number, etc)?

Do you want the pictures imported into XL? Depending on the naming convention, you might be able to write a macro that does something like:

[pre]

Sub FakeCode()
For each c in Range("A1:A10")
StudentName = c.value

'I'm making this part up
ImportFile (FileName:="CMy Documents" & StudentName & ".jpg", Anchor:=c.offset(0,1))
Next C
End Sub

[/pre]
Then you would have a list with names and pictures. After that, you might be done, or you could setup some dynamic picture links if you want to get fancy.