Hi i've just upgraded my Excel from 2000 to 2007 and now this macro have stop working
Dim i As Long
' *** Change Folder name to suit ***
.LookIn = "C:\My Documents"
.SearchSubFolders = True...
Hi I have the Macro below that will search throught a directory and list the .Xls in it. What I am now trying to do with this is to create a hyperlink from the results that will take me right to the spreadsheet?
Is there anything i can easily put in Thanks to anyone that can help :)