grep

  1. R

    GREP software for EXCEL integration

    i am using a GREP application to search for data in files that match a criteria and I want to get the results into EXCEL Can i drag and drop or can i pass a selection back from a file to EXCEL? Also does it matter if the file is already open (Highlight a file on an already open Windows Explorer...
  2. S

    Help with grep-like function

    Hello all, I resurrected an old function someone here helped me build a few years ago but doesn't seem to work in Office 2007. Basically I have a button in a Search tab with this code attached, then I simply enter text into a field (J1) and hit the button. It will then search a different tab...
  3. J

    RegExp: Del !Test(0-*9) with a WinXP .dll?

    I can afford the £200 regex expansion for a simple job, and then have hassle of distributing that. I need to turn: fooTest1234foo into -> Test1234 and things like foofoo123Test23foofoo into -> Test23 So that's a del,! and [0-9]. But the [0-9] number could be any length of digits. I...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 40
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top