+ Reply to Thread
Results 1 to 2 of 2

How to count the number of rows in a list of files

  1. #1
    Registered User
    Join Date
    08-08-2008
    Location
    Johannesburg
    MS-Off Ver
    2007
    Posts
    55

    How to count the number of rows in a list of files

    Hi Guys

    Each month I'm receiving a folder containing 100 files.

    Each file within that folder have 21 rows.
    An headline in row 1 with 20 rows of data.

    From some reasons, sometimes some files are missing few rows.

    Is there a way to check the number of the rows that each file contains
    And get the results on a list, by using a macro?
    i.e.
    Please Login or Register  to view this content.
    Etc'

    Thanks for you kind help
    Using Excel 2007.
    Amit Cohen

  2. #2
    Registered User
    Join Date
    01-26-2009
    Location
    Kansas, USA
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: How to count the number of rows in a list of files

    I don't know how to program the loop to open the files, but here's some easy code to count the number of rows.

    Please Login or Register  to view this content.
    Perhaps I can ask a few more questions that might help others.

    Where are the rows missing? Are they always missing at the end or sometimes in the middle?

    What worksheet in each workbook has the data? Is it always "Sheet 1"?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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