Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fuzzy search/ regexp (2000)

    Just wondering if there is any capability within VBA, or any 3rd party addins, that would facilitate a fuzzy or boolean search of text within cells. Perhaps the use of regular expressions? From my hunt so far, I have found that javascript has this ability (from a wsh/js script) but not vbs. I use the Agent Ransack for such searches of text within files, but it would be nice if the capability was there from within VBA for Excel (and other Office) documents.

    Alan

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fuzzy search/ regexp (2000)

    Try looking in the Online Help for the Like Operator. This facility is also available in non-VBA: look in the Online Help for Wild Cards.
    Gre

Posting Permissions

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