I am needing a macro that will list all files in c:/scans and when it list them then allow me to link to them if possible. But atleast list them

to list folders, adapt Allen Browne's code here: http://allenbrowne.com/ser-59.html

and for changing them all to hyperlinks, loop the range of the column and use the code that you can get from doing one cell manually with the macro recorder.