Closed Thread
Results 1 to 3 of 3

Problem determine last row. Some files are excel 97 some are excel 2007

  1. 06-14-2011, 04:59 PM #1
    welchs101
    welchs101 is offline
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,666

    Problem determine last row. Some files are excel 97 some are excel 2007

    I just figured something out.

    I have this code to determine the last row in a file.

    Please Login or Register  to view this content.
    it works fine when the file is an excel 2007 file. But when the file is an excel 97 file it returns a value of "0".

    Any ideas?
    Reply With QuoteRegister To Reply
  2. 06-14-2011, 05:12 PM #2
    realniceguy5000
    realniceguy5000 is offline
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Problem determine last row. Some files are excel 97 some are excel 2007

    Hi,

    I suppose you could use a smaller number in 97, like Excel 2003 =65536

    Please Login or Register  to view this content.
    Or count the rows like this

    Please Login or Register  to view this content.
    Thank You, Mike

    Some Helpful Hints:

    1. New members please read & follow the Forum Rules
    2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
    3. If you are pleased with a solution mark your post SOLVED.
    4. Thank those who have help you by clicking the scales at the top right of the post.

    Here...
    Reply With QuoteRegister To Reply
  3. 06-14-2011, 05:15 PM #3
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Problem determine last row. Some files are excel 97 some are excel 2007

    welchs, have you looked in your other thread?
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1