I am using Ken Puls code to list files as hyperlinks it finds in a Windows folder. It works great but i am trying to make some changes that better suits my environment. wher it currently show "C:\My Reports\" & list. I know this is wrong but is as close as i can get to it . Can anybody help ?

dim list as string
list = "range ("f4").value

Set ShellApp = CreateObject("Shell.Application"). _ 
        Browseforfolder(0, "Please choose a folder", 0, "c:\My Reports\" & list)