1. G

    Marco Directory Search Problem from excel 2000 to 2007

    Hi i've just upgraded my Excel from 2000 to 2007 and now this macro have stop working Sub Dirlist() Dim i As Long With Application.FileSearch .NewSearch ' *** Change Folder name to suit *** .LookIn = "C:\My Documents" .SearchSubFolders = True...
  2. G

    Directory lookup with hyperlinks?

    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 :) Sub...

Some videos you may like

This Week's Hot Topics