+ Reply to Thread
Results 1 to 59 of 59

VB code Get 2 latest file names from Directory

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB code Get 2 latest file names from Directory

    Hi Leith :

    Thanks a lot for all your help, I am hoping that your family is feeling better now from illness.
    I have tried your work, however, this is what happens.
    I have loaded 3 files with criteria set in Cell A15 to the assigned directory in K1 and folder L1.
    Now when i click on the checkbox in cell I1, it gives error as in attached pic.
    This error is module "Send_Email" :
     .Attachments.Add Files(n), 1, 1, Filename
    Please check and let me if i am doing something wrong.
    Thanks a bunch for all your help.
    Riz
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 11-28-2013, 05:20 PM
  2. Need VBA code to search file in directory and sub-directory and show result
    By johnchencanada in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2012, 11:13 PM
  3. [SOLVED] Reading in files from directory......does this code also alphabetize the file names
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2012, 08:20 AM
  4. Import file size and file names from a directory
    By zahid in forum Excel General
    Replies: 1
    Last Post: 02-07-2006, 09:35 AM
  5. Getting file names in a directory
    By John in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2005, 12:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1