Batch import images into Excel on MacOs

Hello

I'd like to import a couple of hundred images (plus a couple of hundred mp4 movie clips) into an Excel sheet. Each image and each mp4 clip should fill one cell and the cells should have a certain size, so that both are recognisable (stamp size at least). I tried different approaches, but don't get anything to work. Could someone help me using one of those visual basic scripts?

Thanks!

I found a partial solution. This vba script does import images from a URL in collumn A to collumn b


Sub InsertPics2()
'Pictures saved with file
'Set column width (ie, pic width) before running macro

Dim r As Range, Shrink As Long
Dim shpPic As Shape
Application.ScreenUpdating = False
Shrink = 0 'Provides negative offset from cell borders when > 0
For Each r In Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row)
If r.Value <> "" Then
Set shpPic = ActiveSheet.Shapes.AddPicture(FileName:=r.Value, linktofile:=msoFalse, _
savewithdocument:=msoTrue, Left:=Cells(r.Row, 2).Left + Shrink, Top:=Cells(r.Row, 2).Top + Shrink, _
Width:=-1, Height:=-1)
With shpPic
.LockAspectRatio = msoTrue
.Width = Columns(2).Width - (2 * Shrink)
Rows(r.Row).RowHeight = .Height + (2 * Shrink)
End With
End If
Next r
Application.ScreenUpdating = True
End Sub


Problem: they are not linked to the cells, hence they do not move once the table is sorted, which is what I need. Does anyone have a clue how to get that done?