create hyperlink using macro

[reza_doang]

hi all,

just wondering, but hope someone can help me.

i want to have hyperlink for all files in one folder.
i have many files in one folder, using excel macro, can be do automatically.
i.e
in folder ABC i have 10 files from A - J
so in excel it will create
File Link
A.xlsx D:\ABC\A.xlsx
B.xlsx D:\ABC\A.xlsx
C.docx D:\ABC\C.docx
D.pdf D:\ABC\D.pdf
etc

many thanks for your help

reza