code to read files in folders and transfer the file name, type, date created to excel

[Divya577]

Hi Forum,

I am trying to write a code to create a excel file with table based on number of files present in the folder.

the output should look like
SNo, File Name, file type, created date, created by and hyperlink to file

Can someone help me with code.

Regards,
|Divya