+ Reply to Thread
Results 1 to 33 of 33

Search for pdf files by date or title

Hybrid View

  1. #1
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Search for pdf files by date or title

    no the issue is how i constructed the break down
    i only thought there was 3 "-" in the file name but based on what you have told me there is actually 5 "-"
    also is [] around the date for all files as well?

    having it Jul or as a plain number doesnt make a difference
    thats ok ill have a look at it tomorrow

    just block that section out (by putting a ' infront of it) for the time being and if everything else works fine then there is only one line to fix tomorrow

    since im checking to make sure im not making another assumption
    is there any chance that there will be "-" in the name or invoice field?

    ie Mary-Jane brown or INV-09328 or something like that
    i would need to find some other way of splitting the Name-Inv-Date if there is
    Last edited by humdingaling; 05-20-2015 at 03:21 AM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  2. #2
    Forum Contributor
    Join Date
    03-09-2007
    Location
    Australia
    MS-Off Ver
    Office 10
    Posts
    371

    Re: Search for pdf files by date or title

    Sorry there are no brackets in the date I just put them there as an example
    The basic format is as follows

    Brittian - 12312312 - 12-5-15
    Bill - 212131 - 13-5-15

    on rare occasions

    Jones - 12-8-15

    sorry if any confusion

+ 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. many workbooks title into cell after search
    By mrjackt in forum Excel General
    Replies: 0
    Last Post: 03-05-2015, 08:58 AM
  2. Need to search array and return value along with title and row values
    By wilburr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-28-2013, 06:01 AM
  3. [SOLVED] Search files until date is found
    By twckfa16 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2013, 02:57 PM
  4. Using cell contents to search for corresponding sheet title
    By teblowtime in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2013, 03:31 PM
  5. Replies: 3
    Last Post: 04-08-2012, 06:52 PM

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