saving imported picture in excel using vba

[jakeembx]

hi everyone, I'm doing a project in vba that involves uploading different users profile images into there particular record in a spreadsheet, via a excel vba form. does anyone know how to import pictures and save them to the excel file using vba?

thank you!

[Ron Coderre]

Is this something you can use?

The below code
• loops through each cell in the selected range
• reads the filepath from that cell
• inserts the referenced picture in the cell to the right of the cell:
• resizes the height and width of the picture to the cell's height

Please Login or Register  to view this content.

[jakeembx]

thanks for your help! is it possible to add this code to other code that will display a file picker too allow a user to select an image?

[Ron Coderre]

You could have the date picker set a file location variable and pass that variable and the destination cell to the procedure.

Perhaps something like this (Untested)

Please Login or Register  to view this content.

[jakeembx]

is something like this what you mean? or...

Please Login or Register  to view this content.