+ Reply to Thread
Results 1 to 1 of 1

from an excel cell Searching for a string in a document

  1. #1
    Registered User
    Join Date
    03-04-2013
    Location
    Chantilly,VA
    MS-Off Ver
    Excel 2007
    Posts
    9

    from an excel cell Searching for a string in a document

    I have posted this question, differently a couple of times earlier and those went unanswered because it was confusing, I understand. I am finding it difficult to explain in words. I will try to do my best in simpler terms this time without detailing my cell logic (which muddles up the problem definition). Please bear with me.

    I can work with excel spreadsheet quite comfortably and have build complex formulas but, have not done any macros though, and I am not a VB programmer.

    I am trying to search for a 'string' (this is a value in a different cell ) in a 'Word' or 'Txt' file (I have the full path of the file name example: ".\sample.doc" - this is a value in a different cell) and if found then place "Found" else "Not Found" in the cell I am sitting on.

    Can someone Please help.
    Thanks.

    Just an additional note.
    If I copy the contents of the document into a cell within the sheet or another spreadsheet and search that cell, I can get the job done and it works fine. I just do not want to paste the contents in a cell before doing the search. I have many such files so, I will have to do that in each row for each file. That is how I am working now and whenever I have a new document I creae ea new row with a cell pasted with contents of that document. This is very cumbersome.
    Hope this explains the reason for me to search the file directly from the folder location.

    Thanks.
    Last edited by everlearning; 10-09-2013 at 09:03 AM. Reason: Additional clarification why I am seeking help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Searching multiple names in an Excel document
    By Adamantix in forum Excel General
    Replies: 13
    Last Post: 08-04-2013, 02:54 AM
  2. Searching within a string in a cell
    By MikeFranz123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2012, 09:08 AM
  3. Searching for a string in a cell, and then creating a Sheet for that string
    By vmc62 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2008, 12:07 PM
  4. Searching for a string in a cell
    By matpj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2007, 10:12 AM
  5. [SOLVED] searching and summing using string within cell
    By Al in forum Excel General
    Replies: 2
    Last Post: 04-25-2006, 11:10 PM

Tags for this Thread

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