import image filename with vba array & dictionary

[roykana]

Dear All master,

With this, my vba code to import image filenames with an open dialog box can import filenames from folders or subfolders to my excel table.

For the id column, what I mean is before the "-" & "(" sign, then it is included in the id column.

For filename originating from that id, it will fill in the filename column 1 to filename 6. If there is a misunderstanding then you can ask me.
link file : VBA FILENAME IMAGE.xlsm
LINK
Thanks
roykana

 

[roykana]

Dear All Master,
I share a file folder and image sub folder. Please help so that the result can be like below




Link File : KATALOG.7z
link