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

[reza_doang]

hi all,

i think i already get the macro from this forum. but i got some error, can someone fix it.
link:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=232

error:
Unable to get Match property of the WorksheetFunction class

when i press bug, error go to:
NumPos = Application.WorksheetFunction.Match(Ext, X, 0)

thanks

[Kenneth Hobs]

I can not duplicate your problem. What Excel version are you using?

Are you sure that there are files in the selected folder?

[reza_doang]

sorry not mentioned early
i'm using Office Excel 2010 and yes, i already select the correct folder.

the macro work/run but i should delete
On Error Resume Next
NumPos = Application.WorksheetFunction.Match(Ext, X, 0)
If NumPos > 0 Then Excludes = True
On Error Goto 0

Another request, hope someone can modify this vba.
in that vba, it can only read only Master Folder, for sub folder this macro can't read it.
sample
i have Folder ABC, in ABC folder i have 5 files and 2 sub Folder (which contain some files) and so on.
when i run that macro, it only read 5 files and 2 sub folder can't be read.

many thanks
reza