Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Search All Excel Files On Drive If Data Already There

    Hi All,

    I have many Excel files on my F-drive which hold international stock data.

    Some of them will be deleted and others will be added.

    I like to know if it is possible to look for a specific company name already contained in a file.

    For example: I want to lookup FOCUS GRAPHITE INC from a table which changes daily according to Stock Exchange entries.
    If not found I will have to create a new record in my summary file which is quite big.

    I enclose a sample table file which shows a few entries only (Excel 2007).

    The data in question may me on any sheet in any position.

    As always, I thank you very much for your kind help in advance.

    Best regards,

    Wolfgang
    Attached Files Attached Files
    Last edited by wolfgang; 2013-11-16 at 08:18. Reason: Attatchment missing...

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I am not sure exactly what you want. Windows explorer can search for text within files to see what files have it on Drive F...

    If you are looking for some automation in a macro, you will need to walk us through exactly what you want the code to do.

    Steve
    PS for an open file, Ctrl-F can search for text

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts
    Hi Steve,

    thank you very much for your fast reply.

    I don't know if Windows explorer can search thru binary files, I will try this.

    All of my Stock-files are .xlsb files.

    Let me check out your suggestion first and I will let you know about it.

    Best,
    Wolfgang

  4. #4
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts
    Steve,

    I tried your suggestion and explorer found some occurrences but not all of them, strange.

    Basically, the code should exactly do what I just did using explorer: look thru all Excel binary files and find the name of the company which I will input.

    Something like an input menu which accepts the name of a company and tell me if found or not and the name of the Excel file which contains the name I am looking for.

    I realize that my questions may sound weird to all of you friendly experts but what can you expect from an Financial Analyst...

    Wolfgang

  5. #5
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,638
    Thanks
    115
    Thanked 650 Times in 592 Posts

  6. The Following User Says Thank You to Maudibe For This Useful Post:

    wolfgang (2013-11-16)

  7. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    If explorer is not finding them, it is either stored in a different format that explorer can not read or you may have to reindex explorer.

    I don't want a "basically" of what you want the code to accomplish unless you want an answer about basically what to do. Some "basically" responses could come from searching this site for other questions on searching through folders and then adapting the code

    If you want specific help, I would need specifics of what you want to accomplish. Please walk me through the details of what you have and what you need and what you want from the code.

    Steve

  8. #7
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts
    Steve,

    explorer does find all files that contain "focus" in the file name and some that contain "focus" somewhere in the file.

    I looked at Maudibe's solution and it finds all occurrences of "focus" in all *.xlsb files which is exactly what I wanted.

    I thank you for your patience and help, have a nice weekend.

    Best regards,

    Wolfgang

  9. #8
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts
    Hi Maude

    Have a nice weekend, too.

    Best regards,

    Wolfgang

  10. #9
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi Maude

    ..I knew that adding the amendment in that post for including binary .xlsb files in the search would come in handy one day.
    Top marks!

    zeddy

  11. #10
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,638
    Thanks
    115
    Thanked 650 Times in 592 Posts

Posting Permissions

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