Auto link from excel to folder's files

thank you so much
is there any way to make it insert the folder too?

and my main question is are there any way to add the file to the sheet automatically without running the macro, and it happened once I open the file that contains the macro ??
(make the macro work automatically by opening the file and go to a specific folder determined in it and list all folders in columns with their files )

again THANK YOU SO MUCH , IT IS REALLY HELPFULL CODE