+ Reply to Thread
Results 1 to 2 of 2

Search for a string in multiple excel files with multiple sheets

  1. #1
    Registered User
    Join Date
    08-09-2012
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2003
    Posts
    1

    Search for a string in multiple excel files with multiple sheets

    Hello Guys,

    I'm very new to VBA programming, and need some help in learning on how / or if the below workflow can be improved.

    In order to reduce the manual work that i am put to do, i am searching for a macro that can search for a string in multiple excel files with multiple sheets from a shared drive on my network. The files are constantly updated, that's why the search should be made from a shared drive.
    The result should also enumerate all the excel files that we're searched and in case of hits it should point out XLS file/ xls sheet/ and the column or cell.

    Ideally, after the above will be sorted out, i will look for a way in instructing Office in doing the following:
    1. Printscreen with the result
    2. New Worddocument and paste printscreen
    3. Save document in a specified by me network path with the following name "String name/dateofsearch''.doc

    Is this doable?

    Really appreciate the help/guiding.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Search for a string in multiple excel files with multiple sheets

    I've got this far, but the link isn't working. Maybe tomorrow.

    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

+ 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