Results 1 to 2 of 2

Thread: find files

  1. #1
    Join Date
    Aug 2004
    Posts
    178

    Unanswered: find files

    i am looking for code to find all files in a dir and sub dir then email them they will be excell files. i need to find only file that have been modifed yesterday

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    From the Excel Help File

    Code:
    Sub lstModified()
        'from helpfile excel 2002
        Set fs = Application.FileSearch
        With fs
            .LookIn = "C:\My Documents"
            .SearchSubFolders = True
            .LastModified = msoLastModifiedYesterday
        End With
    End Sub
    and im sure there is VBA for e-mailing files on here try a search
    HTH
    Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •