+ Reply to Thread
Results 1 to 3 of 3

Determine number of files in a dynamic directory

  1. #1
    Registered User
    Join Date
    12-18-2013
    Location
    Germany
    MS-Off Ver
    Excel 2003
    Posts
    24

    Determine number of files in a dynamic directory

    Hello everyone,

    I don't know if I ask too much, but is it possible if I have a directory like the following

    Please Login or Register  to view this content.
    with .csv files which are placed in arithmetic order 01,02,03 etc to determine if one .csv file is missing and print an error that this file is missing? I think that if I knew how many files I got I would create an array and check one by one the files.. But in case I have a dynamic directory and the number of files is not the same all the time , is this possible?

    Thank you in advance,
    Desolatori

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Determine number of files in a dynamic directory

    Consider:

    Please Login or Register  to view this content.
    Gary's Student

  3. #3
    Registered User
    Join Date
    12-18-2013
    Location
    Germany
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Determine number of files in a dynamic directory

    Thank you for the reply but I don't really get it.. This will print the total number of files which are in the folder right? How shall I use the i counter in order to realize that a file is missing.

+ 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. Moving Files from one directory structure to another directory
    By harddd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2013, 02:39 PM
  2. Reading in the files in a directory into an array, directory chosen by user
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2011, 12:52 PM
  3. Check Number of Files in Directory
    By dvent in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2007, 10:13 PM
  4. Determine number of open excel files
    By gw.boswell@gmail.com in forum Excel General
    Replies: 4
    Last Post: 05-25-2006, 10:10 AM

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