Results 1 to 3 of 3

Thread: search massive

  1. May 26th, 2006, 08:13 PM #1
    lynch44
    lynch44 is offline

    Thread Starter
    New Member
    Join Date
    May 2006
    Posts
    2

    search massive

    Hi,

    i have a real large file for excel, about 200.000 - 400.000 rows ...

    i am using new office 12 pre-release for this ... also using assistance of previous versions (because some codes do not work in office 12)

    and i need to see how many info that i like to display in my document ...


    my info is like ...

    70
    72
    70
    74
    71
    75

    ... and 200.000 - 400.000 like this one ...


    HERE, i need to find about 500 info like above in my document ...

    like again ...

    70
    74
    73
    71
    70
    72

    so forth ...


    simply, i could not search one by one how many 500 info in my document ...

    i need a solution that search all 500 info which i'll enter like above, in one action ..

    and also i like to DISPLAY how many of each ...


    i do not know is it possible ...

    for people who like to know, i need it for visual-audio programs and creativity ...

    thanks and regards ...
    Reply With Quote Reply With Quote
  2. May 26th, 2006, 08:44 PM #2
    MartinLiss
    MartinLiss is offline
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431

    Re: search massive

    Moved.
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
  3. May 26th, 2006, 10:17 PM #3
    Al42
    Al42 is offline
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: search massive

    I thought Excel was limited to 65,535 rows.
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.
    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.
    Please Help Us To Save Ana
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width